LinqPad 6 SQL tab displaying the generated SQL multiple times.
When viewing the SQL for a Linq query I often get the same SQL script displayed repeatedly. Is this something that is being generated by my Query or is it some sort of issue with LinqPad 6?
Comments
-
What kind of connection is it?
-
In some cases, with some providers e.g. EF Core 2.1, it will convert a single query into multiple SQL queries - you can tell because the parameter values with the query vary.
-
The connection type is Entity Framework Core 5 DbContext
Does the creation of multiple SQL statements mean that it is doing that in my actual program?
-
Does it show multiple statements when you execute a simple query, such as Customers.Take(100)?
And are you allowing LINQPad to generate the data context automatically, or are you connecting to your own data context assembly?
-
Simple query returned 1 query.
Ran a simple Take(10) query on a different table and got two identical queries in the SQL tab.
Connecting to my own EF .Net 5 data context assembly.Using LINQPad 6 Beta
**Update
Ran the simple query repeatedly in LINQPad, Every time I ran it it added a duplicate to the SQL query tab. Is this the expected behavior? Or should the SQL tab clear each time? Is there a way to clear the screen between runs of the query?
