.net – 将LINQ翻译成sql语句

前端之家收集整理的这篇文章主要介绍了.net – 将LINQ翻译成sql语句前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我想将LINQ表达式树翻译成sql语句,我不想​​为此编写自己的代码.

例:

var query = from c in Customers
where c.Country == "UK" &&
      c.City == "London"
select c);

SELECT ... FROM Customers AS c WHERE c.Country = "UK" AND c.City = "London"

我知道DataContext.Log,但我想使用:

query.TosqlStatementString()

解决方法

CustomDataContext dc = new CustomDataContext();
IQueryable<Customer> query =
  from c in dc.Customer
  where c.Country == "UK"
  select c;
//
string command = dc.GetCommand(query).CommandText;

猜你在找的MsSQL相关文章