HowTo: LINQ to SQL debugging
I`m working on a project where I use LINQ to SQL. It´s very cool (and sometimes tricky ), but what if I need deeper information about the "LINQ to SQL magic" – how can I debug the LINQ to SQL stuff?
1. Option: Visual Studio
The simplest option is of course Visual Studio itself. Just checking the objects – very easy.
If you want to know which SQL statement is send to the SQL Server you need another tool:
2. Option: LINQ to SQL Debug Visualizer
A powerful tool: LINQ to SQL Debug Visualizer. I can´t understand why Microsoft hide this handy tool.
3. Option: DataContext.Log
A build-in option for logging is the DataContext.Log property. It is very useful in a consol application – but not in a class library. I found a very smart "Output Logger" class on this blog: Sending the LINQ To SQL log to the debugger output window. Each generated sql statement will be send to the output window.
This are my "debugging" tools – maybe could "LinqPad" another nice tool.
Any other suggestion? Feel free to comment (you can even comment my english ).