SQL query generated by LINQ TO SQL statement

How would i know the SQL statement generated by开发者_如何学运维 my Linq to sql query?

---

You could see the SQL statement by using the toString() statement.

var customers = from cust in Customers
        select cust;

Console.WriteLine(customers.ToString());

or you could do something like this.

DataContext context = new DataContext(...);
StringWriter writer = new StringWriter();
context.Log = writer;

var customers = from cust in Customers
        select cust;

Console.WriteLine(writer.ToString());

---

Use LINQ to SQL Debugger Visualizer.

Alternatively, you can set dataContext.Log property to Console.Out or something and the SQL statement, along with actual parameter values will be written out to that stream.

---

There is a tool to check the query http://www.linqpad.net/