Get generated sql by EF6 on method chaining

Question

A simple search on getting generated SQL by EF6 returns lots of results, even many in Stackoverflow. but none of them has suggested any ways when method chaining is used.

For example(How do I view the SQL generated by the Entity Framework?):

IQueryable query = from x in appEntities
             where x.id = 32
             select x;

var sql = ((System.Data.Objects.ObjectQuery)query).ToTraceString();

but I want to get the generated sql query if it was used like:

appEntities.x.Where(x.id==32);

You want to check something or will use that sql string somehow? — SᴇM, Jun 01 '18 at 13:15
I'm facing a very funny problem with a `.Any` method: [https://stackoverflow.com/questions/50643128/linq-any-always-returns-true](https://stackoverflow.com/questions/50643128/linq-any-always-returns-true). I'm trying to see what sql query it runs that it returns a wrong value. — Ashkan Mobayen Khiabani, Jun 01 '18 at 13:18
`appEntities` doesn't have a property `x`. Please ask a clear question. — Gert Arnold, Jun 01 '18 at 13:39
@GertArnold appEntities is a Context, x is a table and has a property named id (x.Id) — Ashkan Mobayen Khiabani, Jun 01 '18 at 14:56
Then you can't do `from x in appEntities where ...`. It really doesn't help to use pseudo code in questions. — Gert Arnold, Jun 01 '18 at 15:01

SᴇM · Accepted Answer · 2018-06-01T13:54:47.280

3

You can use Diagnostic/Profiling Tools

Debug -> Windows -> Show Diagnostic Tools ( Ctrl+Alt+F2)

inside Visual Studio, then, while debugging, go to Events tab and click on ADO.NET event (or just hover), which will contain the actual sql string queried to DB.

Or you can add this line

dbContext.Database.Log = s => Debug.WriteLine(s);

before your queries and it will print out your queries inside Output -> Debug.

Or store inside some string if you prefer:

//TODO: Remove after checking
StringBuilder log = new StringBuilder();
dbContext.Database.Log = s => log.Append(s);

edited Jun 01 '18 at 13:54

answered Jun 01 '18 at 13:27

SᴇM

7,024
3
24
41

@AshkanMobayenKhiabani where it returns null? It supposed to print out log inside Output tab after your query will be executed. – SᴇM Jun 01 '18 at 13:51
You know, `appEntities` is an `ObjectContext`. – Gert Arnold Jun 01 '18 at 13:51
I changed your code to assign the value to a string instead of printing it. – Ashkan Mobayen Khiabani Jun 01 '18 at 13:52
@AshkanMobayenKhiabani Also an option. – SᴇM Jun 01 '18 at 13:53

Get generated sql by EF6 on method chaining

1 Answers1