CODEWITHSUNDEEP
c#entity-framework-4linq-to-entitiesentity-sql
Sean
Sean

Reputation: 203

Viewing Entity SQL produced by Linq-to-Entities

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!

Upvotes: 6

Views: 1364

Answers (3)

Sunil Kumar
Sunil Kumar

Reputation: 99

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 https://i.sstatic.net/t6PK6.png

Upvotes: 0

Somedeveloper
Somedeveloper

Reputation: 867

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());

Upvotes: 1

Devart
Devart

Reputation: 122032

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.

Upvotes: 8

Related Questions