从LINQ到SQL获取SQL查询？ [英] Get SQL query from LINQ to SQL?

问题描述

我有一个查询，我通过 byte [] 作为参数。我试图从SQL Server中获取SQL查询，并在管理工作室中运行该查询来进行调试。如何从中提取SQL语句？

I have a query which I am passing byte[] as a parameter. I am trying to get the SQL query out of it and run that query in management studio to debug. How can I extract the SQL statement from it?

 committeeMember =
           db.Committee_Member.FirstOrDefault(x => x.Customer_Number == activity.Contact.Number
           && x.Position_Start_Date.Value.Year == activity.EndDate
           && x.Committee_Id == activity.Committee.Id && x.Cancelled != 1);

推荐答案

在调试器中将鼠标悬停在 commiteeMember 变量 - 它将显示生成的SQL查询：

In debugger hover mouse over commiteeMember variable - it will show generated SQL query:

这是 ToString（）返回查询。您可以通过调用ToString手动获取相同的生成的SQL查询：

This is what ToString() returns for query. You can get same generated SQL query manually by calling ToString:

string sql = committeeMember.ToString();

此重写方法内部调用 ObjectQuery.ToTraceString（） 返回将在数据源上运行的命令。

This overridden method internally calls ObjectQuery.ToTraceString() which returns commands that will run on data source.

此外，您还可以使用SQL Profiler或Entity Framework Profiler查看执行的SQL查询。

Also you can use SQL Profiler or Entity Framework Profiler to see which SQL query was executed.

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