How to profile Entity Framework activity against SQL Server?

Question

It's easy to use SQL Server Profiler to trace stored procedures activity. But how to trace SQL queries issued by LINQ via Entity Framework? I need to identify such queries (LINQ code) that consume a lot of time, are called most frequently and therefore are the first candidates for optimization.

Answer 1

Add this key to your connection string:

Application Name=EntityFramework

And filter by this in Profiler