How can I find out what the TSQL Entity Framework generates for a query?

Question

Submit this linq request:

return db.Projects.Where(p => p.ProjectID == id);

How can I find out what TSQL generates?

Answer 1

I am using LINQPad

You can see your queries as lambda expressions or SQL

Answer 2

SQL Server Profiler does just that. If you are on SQL Server Express, there is an open source alternative called AnjLab Sql Profiler because the SQL server profiler is not included in express.

Answer 3

Sql Server Profiler . , EF.