You may be curious about the T-SQL that LINQ is generating for this .NET expression. To reveal this mystery, you can use two tools: SQL Server Profiler and Linqpad. To use Profiler, launch the application from the Windows Start menu, create a new trace using the File menu (select New Trace), and connect to your database of choice. On the ensuing Trace Properties dialog, select the trace template called
T-SQL_SPs, start the trace, and then run the LINQ statement found in Listing 45.3. The T-SQL that LINQ generates is revealed in the
Alternatively, you can download and use the amazing Linqpad from http://www.linqpad.net. Visit the site and download
Linqpad.exe. Save it to a folder that you will ...