How can I debug EF? (analyze SQL queries)

How can I debug the Entity Framework? Can I see which queries it is actual开发者_Python百科ly trying to execute to the SQL server, to troubleshoot issues?

---

Check out the MVC Mini Profiler: http://code.google.com/p/mvc-mini-profiler/

It's very lightweight, doesn't intrude on your app, and is easily removed if need be. Plus, Stack Overflow uses it.

---

You can cast your query to ObjectQuery and then use ObjectQuery.ToTraceString() - that returns the full SQL for your query. Alternatively of course you can simply use SQL Profiler on your database to see what SQL gets executed.

---

You can use Entity Framework Profiler. http://efprof.com/.

---

You could use a Monitoring tool from the Server to watch the queues directly.
For MSSQL Server see: http://blog.pengoworks.com/index.cfm/2008/1/3/View-recently-run-queries-in-MSSQL-2005