LINQ to SQL. Visualizer Debugger not showing SQL
In this example, this screen shot of the video shows that if you click on the following magnifying class tooltip, it will bring up a debugger开发者_如何转开发 that shows you the SQL tghat the LINQ statment has been converted into:
However, when I download the sample VB code and run it and try to do the same thing in VS2010 Ultimate, I see the following. Notice that the magnifying lense visualizer icon is not available.
What am I missing? Do I need to install a separate debugger? My dataset visualizer works fine...
I'm not sure why the visualizer is not working for you, but in case you don't find a solution another (less convenient) way to view the SQL is to assign a TextWriter
(for example Console.Out
) to DataContext.Log
.
You can see the queries being executed through SQL server profiler.
精彩评论