Debugging Entity Framework SQL statements

by

For debugging EF queries, the easiest thing is to cast the query to ObjectQuery and use ToTraceString:

var query = myContext.MyTable
    .Where(r => r.Id == searchId)
    .Select(r => r);

Console.WriteLine(((ObjectQuery)query).ToTraceString());

This will show the underlying SQL for the query, and you can run the queries manually to debug why they are slow. Here is the MSDN link:

http://msdn.microsoft.com/en-us/library/system.data.objects.objectquery.totracestring.aspx

If you’re trying to get the SQL which is run when you call SaveChanges() on your context, it’s not as easy. You could take a look at EFTracingProvider:

http://blogs.msdn.com/b/jkowalski/archive/2009/06/11/tracing-and-caching-in-entity-framework-available-on-msdn-code-gallery.aspx

Or, assuming you use SQL Server, you can go directly to SQL Profiler and capture the T-SQL statements (this is my preferred approach).

More Related Contents:

  1. How many Include I can use on ObjectSet in EntityFramework to retain performance?
  2. Entity Framework query slow, but same SQL in SqlQuery is fast
  3. How to avoid Query Plan re-compilation when using IEnumerable.Contains in Entity Framework LINQ queries?
  4. Speed up the loop operation in R
  5. One could use a profiler, but why not just halt the program? [closed]
  6. Spark functions vs UDF performance?
  7. Adding a redundant assignment speeds up code when compiled without optimization
  8. Why is this SSE code 6 times slower without VZEROUPPER on Skylake?
  9. Faster way to find the first empty row in a Google Sheet column
  10. 32-byte aligned routine does not fit the uops cache
  11. Why is SSE scalar sqrt(x) slower than rsqrt(x) * x?
  12. Haskell foldl’ poor performance with (++)
  13. Which Intel microarchitecture introduced the ADC reg,0 single-uop special case?
  14. Storing Documents as Blobs in a Database – Any disadvantages?
  15. Can modern x86 implementations store-forward from more than one prior store?
  16. Cellfun versus Simple Matlab Loop performance
  17. timing code in matlab
  18. Simulating Slow Internet Connection [closed]
  19. What is the difference between spark.sql.shuffle.partitions and spark.default.parallelism?
  20. What’s the actual effect of successful unaligned accesses on x86?
  21. LOWER LIKE vs iLIKE
  22. Most efficient code for the first 10000 prime numbers?
  23. dbms_output.put_line
  24. Why do these goroutines not scale their performance from more concurrent executions?
  25. Cycles/cost for L1 Cache hit vs. Register on x86?
  26. Redis 10x more memory usage than data
  27. Best Practices for Multiple OnEdit Functions
  28. How to optimize gradle build performance regarding build duration and RAM usage?
  29. How to find Cumulative Layout Shift problems if Page Speed Insights says one thing and Search Console says another
  30. SET vs. SELECT – What’s the difference?

Leave a Comment