Linqpad Performance vs Sql Management Studio

Question

I have a Linq query that I run in Linqpad against EF5 and it works for about 10 seconds. When I copy the generated SQL for this statement to SMS, it works in less than 2 seconds.

Obviously, EF adds more processing overhead than direct SQL, and LinqPad runs on my computer, not the server. Therefore, I expect it to be a little slower.

But is there a way to track Linqpad and EF request execution steps so that I can identify bottlenecks?

Thanks!

Answer 1

Ants Profiler linqpad - .

SQL- LINQ, LINQ - . , LINQ SQL. LINQ (LINQ , ), .