Quick tip: If you want to see the SQL generated by LINQ to SQL for a query or command, simply set the Log property of your generated DataContext class to an instance of a TextReader.
If this is your code:
using System;
using System.Linq;
using System.Data.Linq;
namespace LINQtoSQLConsole {
class Program {
static void Main(string[] [...]
Lesen Sie den vollständigen Eintrag unter http://richardbushnell.net/index.php/2008/02/14/how-to-see-the-sql-generated-by-a-linq-to-sql-command/