LINQ to SQL Debug Visualizer

If you are using LINQ-to-SQL, it is often helpful to see the SQL generated and the resultant query results.  You can do this, even while debugging, with the LINQ to SQL Debug Visualizer.  Debug Visualizers are the dialogs that pop up when you hover over a statement and click the little magnifying glass in the hovering menu.

I believe by default Visual Studio will show you the generated SQL when you over over a LINQ statement, but there is no way Debug Visualizer to help see the SQL in a more user-friendly view.  Scott Guthrie gave a blog post describing a simple download that can give you this enhanced view of the SQL, and even the ability to execute the query and see the raw data returned from your database:

http://weblogs.asp.net/scottgu/archive/2007/07/31/linq-to-sql-debug-visualizer.aspx

Included in the post are instructions of how to extract the necessary DLL library, and where to place it in Visual Studio’s file hierarchy.

A really simple enhancement for working with and debugging LINQ-to-SQL that is definitely worth the minimal effort to acquire it.

Comments

Raja Venkatesh
Hi, A similar visualizer for L2E is available at http://visualstudiogallery.msdn.microsoft.com/en-us/99468ece-689b-481c-868c-19e00e0a4e69
This works for any database.

Regards
Venkat