Clever Geek Handbook

How to profile Entity Framework activity against SQL Server?

Easy to use SQL Server Profiler to track stored procedure activity. But how to track SQL queries issued by LINQ through Entity Framework? I need to identify such queries (LINQ code) that are time consuming, named most frequently, and therefore are prime candidates for optimization.

+3


source to share


1 answer


Add this key to your connection string:

Application Name=EntityFramework


And filter this in the profiler

+3


source






More articles:


All Articles