从 LINQ 到 SQL 获取 SQL 查询?

问题描述

我有一个查询，我将 byte[] 作为参数传递.我正在尝试从中获取 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 查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！