How to identify problems with n + 1 in Linq to SQL?

Question

What is the best way to detect n + 1 selection issues if I use linq for SQL, we are currently working on a project and it seems to display some lists quite slowly. What is the best method to detect this?

Answer 1

Perhaps this will help:

http://ayende.com/Blog/archive/2009/11/13/linq-to-sql-profiler-is-now-on-public-beta.aspx http://weblogs.asp.net/scottgu/archive /2007/07/31/linq-to-sql-debug-visualizer.aspx http://visualstudiogallery.msdn.microsoft.com/ru-ru/d5a64d5a-174a-4357-ad84-dbeeec030f23

SQL Profiler , .

Answer 2

n + 1 , , SQL.

DataContext.Log TextWriter, SQL . , . Linq to SQL DebuggerWriter. DebuggerWriter.

DataContext db = new DataContext();
#if DEBUG
db.Log = new DebuggerWriter();
#endif