LINQ TO SQL语句生成的SQL查询 [英] SQL query generated by LINQ TO SQL statement

问题描述

我怎么知道Linq to sql查询生成的SQL语句?

How would i know the SQL statement generated by my Linq to sql query?

推荐答案

您可以使用toString()语句查看SQL语句.

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());

这篇关于LINQ TO SQL语句生成的SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！