In my previous post I showed you three different ways to capture the T-SQL query generated by LINQ To SQL. A comment on the post reminded me that I forgot to mention a fourth way i.e. using Linqpad. In Linqpad when you have executed the query you can click on the SQL tab next to Results and look at the T-SQL query.

Other than viewing generated queries, Linqpad is also a great tool for writing queries. The tool itself is very lightweight and comes with many templates to get you started.