Viewing Entity SQL produced by Linq-to-Entities

6
votes

Is there a way I can view the Entity Sql (eSQL) that my Linq-to-entities queries are generating with EF framework (that is, not native SQL, but eSQL, if that makes sense?)

Thanks!

3
c#entity-framework-4linq-to-entitiesentity-sql

3 Answers

8
votes

You can't. It is not generated.
Actually, LINQ to Entities queries are translated directly into Expression Tree, and the nodes of this Expression Tree are translated into SQL clauses, and then integrated into a SQL query. No Entity SQL.

1
votes
var query1 = from person in Database
           select person.Name;

You can cast the query1 into ObjectQuery and use the ToTraceString method to see the query.

Console.WriteLine(((ObjectQuery)query1).ToTraceString());
0
votes

To view linq query in development environment.

  1. You assign your query in IQueryable variable.
  2. Plase debug point below the query in next line. So, Query get executed.
  3. Place mouse over the IQueryable variable. You will be able to see the SQL query.
  4. You can copy your sql query in SQL query analyser and execute it.

view example in image http://i.stack.imgur.com/t6PK6.png