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...