How to get the sql generated by the entity framework

Question

How can I get the sql script generated by an entity framework query? i.e. If I write

entityDataDontext.table1.Where(r => r.primarykey == 1).First();

then how can I get the SQL which should be somewhat like this:

select * from table1 where primarykey = 1

Thanks in advance :)

I'd like to add to @RPM1984 comment that to use this against an anonymous type you would use `ObjectQuery` rather than `ObjectQuery`. — The Muffin Man, Jun 26 '12 at 22:04
Please see duplicates: [How do I view the SQL generated by the entity framework ?](http://stackoverflow.com/questions/1412863/how-do-i-view-the-sql-generated-by-the-entity-framework) [SQL tracing LINQ to Entities](http://stackoverflow.com/questions/137712/sql-tracing-linq-to-entities) — Kip, Jan 15 '11 at 16:01

score 5 · Answer 1 · answered Jan 15 '11 at 15:32

5

When you're going against SQL Server as your backend database, SQL Server Profiler is always the best tool to see exactly what SQL statements are being sent to your database to be processed.

See Introducting SQL Server Profiler for background info.

answered Jan 15 '11 at 15:32

marc_s

732,580
175
1,330
1,459

score 2 · Answer 2 · answered Jan 27 '13 at 20:19

2

I can strongly recommend MiniProfiler: http://miniprofiler.com/

answered Jan 27 '13 at 20:19

Mariusz.W

1,347
12
19

score 0 · Answer 3 · answered Jan 15 '11 at 15:37

0

Besides using the SQL Server Profiler, you can try Entity Framework Profiler, which does that and more.

It's paid, with a 30-day trial.

answered Jan 15 '11 at 15:37

Diego Mijelshon

52,548
16
116
154

I have used this earlier, it's a very good tool. The only problem is that it is paid :( – Gaurav Pandey Jan 17 '11 at 05:22

How to get the sql generated by the entity framework

3 Answers3

Linked