Count the number of database hit were made

[desanti]

Hello ! I'm using entity framework Is there any way to count how many database hit were made ? ( The reason why I make this question, is because i'm using a 3d party software that add some commands to Entity Framework. One of these is that several different queries (the software claim) are executed using a single database hit. I want to verify this.) Thank you !

[Lost User]

If you can't tell the difference, what does it matter?

The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.' ― Confucian Analects

[desanti]

I want to know if this software is telling the truth or no , if yes I want to use it.

[Lost User]

Everyone lies.

The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.' ― Confucian Analects

[desanti]

Are you Gerry Schmitz ?

[Mycroft Holmes]

It is quite possible to send multiple queries in a single request, look up "Little Johnny Tables", that is called sql injection. You can also get multiple result sets returned in a single request using a dataset, although this was painfully slow when I last looked (about 6 years ago). If you are using SQL Server then sql profiler will allow you to inspect each call to the database.

Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

[desanti]

i'm trying a 3d party tools Query Future | Entity Framework Plus[^] But i'm not sure if it's true what this tool claim to do ? The sql profiler it says : exec sp_executesql N'---EF+ Query Future 1 of 5....... .After there are 5 queries (I have 5 query that are executed with Future) But i don't know if these queries are executed in a single database hit ?

[Richard Deeming]

There are several options:

• Use the SQL Server profiler[^];
• Use a tool such as MiniProfiler[^] to profile your EF queries;
• For EF6, use the built-in logging and tracing options[^];
• For EFCore, use the different built-in logging and tracing options[^];

---

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer