The debugger visualizer for LINQ to SQL displays the raw SQL generated by the query. With a single click, the query can then be executed the query with the results being displayed in standard grid.
The LINQ to SQL debugger visualizer is not shipped with Visual Studio 2008, but you can download the source code for it from Scott Guthrie.
For more information on creating your own Debugger Visualizer in Visual Studio 2005, check out David Hayden's Article.