SQL query generated by LINQ TO SQL statement

Question

How can I recognize the SQL statement generated by my Linq to sql query?

Answer 1

You can see the SQL statement using the toString () statement.

var customers = from cust in Customers
        select cust;

Console.WriteLine(customers.ToString());

or you can 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());

Answer 2

Use LINQ to SQL Debugger Visualizer .

Alternatively, you can set the property to a dataContext.Logvalue Console.Outor something similar, and the SQL statement, as well as the actual parameter values, will be written to this stream.

Answer 3

http://www.linqpad.net/