blocks|key|3187360|text|商业工具ORM+Profiler、Entity+Framework+Profiler或Hugati+Query+Profiler都将为您提供生成SQL的方法的堆栈跟踪。这使得在代码中查找LINQ相当容易，尽管它不是直接显示的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3187361|这些工具还有一个优点，那就是它们可以很容易地在应用程序执行的许多其他SQL语句中查找低效查询。|3187362|entityMap|0|LINK|mutability|MUTABLE|url|http://www.ormprofiler.com/|1|http://efprof.com/|2|http://www.huagati.com/L2SProfiler/^0|4|C|0|H|P|1|17|L|2|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]|$A|V|B|W|1|X]|$A|Y|B|Z|1|10]]|C|$]]|$1|D|3|E|5|6|7|11|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]|P|$5|I|J|K|C|$L|Q]]]]

The commercial tools <a href="http://www.ormprofiler.com" rel="nofollow">ORM Profiler</a>, <a href="http://efprof.com" rel="nofollow">Entity Framework Profiler</a> or <a href="http://www.huagati.com/L2SProfiler/" rel="nofollow">Hugati Query Profiler</a> will both give you a stack trace for the methods which generated the SQL. That makes it fairly easy to find the LINQ in code, though it isn't displayed directly.

These tools also have the advantage that they make it easy to find inefficient queries amongst the many other SQL statements executed by the app.

blocks|key|5085010|text|尽管它不是免费工具，但它可能会提供您需要的信息：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5085011|http://efprof.com/|offset|length|5085012|这里还描述了一个不太昂贵的工具，我没有用过，但它看起来很有前途：|5085013|http://huagati.blogspot.com/2010/06/entity-framework-support-in-huagati.html|5085014|http://www.huagati.com/L2SProfiler/|5085015|entityMap|0|LINK|mutability|MUTABLE|url|1|2^0|0|0|I|0|0|0|0|24|1|0|0|Z|2|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@$D|W|E|X|1|Y]]|A|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|10|8|@]|9|@$D|11|E|12|1|13]]|A|$]]|$1|J|3|K|5|6|7|14|8|@]|9|@$D|15|E|16|1|17]]|A|$]]|$1|L|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|C]]|S|$5|O|P|Q|A|$R|I]]|T|$5|O|P|Q|A|$R|K]]]]

Although it is not a free tool, this may provide the information you need:

<a href="http://efprof.com/" rel="nofollow">http://efprof.com/</a>

There is also a less expensive tool described here, which I have not used, but it looks very promising:

<a href="http://huagati.blogspot.com/2010/06/entity-framework-support-in-huagati.html" rel="nofollow">http://huagati.blogspot.com/2010/06/entity-framework-support-in-huagati.html</a>

<a href="http://www.huagati.com/L2SProfiler/" rel="nofollow">http://www.huagati.com/L2SProfiler/</a>

blocks|key|5085186|text|我打赌实体框架分析器(http://efprof.com/)会帮到你。工作流程与您所要求的非常不同(顺便说一句，这将是非常酷的)。这是一个很好的工具，即使它不是你的最终解决方案，也值得一看。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5085187|祝好运!|5085188|entityMap|0|LINK|mutability|MUTABLE|url|http://efprof.com/home^0|B|I|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

I bet Entity Framework Profiler (<a href="http://efprof.com/home" rel="nofollow">http://efprof.com/</a>) would help you out. The workflow is very different from what you asked for (which would be pretty cool BTW). It is a good tool, and is worth a look even if it's not your final solution.

Good luck!

blocks|key|4802633|text|如果您可以访问LINQ代码所在的ASP.NET代码，则可以或多或少地知道您正在查找哪个查询，将其复制到一个名为LINQPad的免费软件工具中，并在那里直接运行它，以获得生成的SQL语句。http://www.linqpad.net/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4802634|您首先需要在.net代码上获取LINQ查询，创建到数据源的连接，将Linq代码粘贴到新查询中并运行它们。您将获得从LINQ代码生成的SQL查询。|4802635|例如：|4802636|from+e+in+ETUSERs
where++e.LoginName.Contains("a")
orderby+e.LoginName
select+e|code-block|syntax|javascript|4802637|SQL结果选项卡：|4802638|--+Region+Parameters
DECLARE+@p0+VarChar(1000)+=+'%25a%25'
--+EndRegion
SELECT+[t0].[UserID],+[t0].[UsrFirstName],+[t0].[UsrLastName],+[t0].[LoginName],+[t0].[Location],+[t0].[Password],+[t0].[UsrEmail],+...
FROM+[ETUSER]+AS+[t0]
WHERE+[t0].[LoginName]+LIKE+@p0
ORDER+BY+[t0].[LoginName]|4802639|这可能不是您想要的，但了解这个工具是值得的，因为它对快速测试LINQ查询非常有帮助。在那里，您可以快速编辑和运行以改进代码，而无需重新编译所有内容。|4802640|entityMap|0|LINK|mutability|MUTABLE|url|http://www.linqpad.net/^0|2L|N|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|6|7|14|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|15|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|16|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|17|8|@]|9|@]|C|$]]|$1|O|3|P|5|J|7|18|8|@]|9|@]|C|$K|L]]|$1|Q|3|R|5|6|7|19|8|@]|9|@]|C|$]]|$1|S|3|-4|5|6|7|1A|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]]]

If you have access to the ASP.NET code where the LINQ code is you can more or less know which query you are looking for, copy it into a freeware tool called LINQPad and run it directly there to get the generated SQL statements. <a href="http://www.linqpad.net/" rel="nofollow">http://www.linqpad.net/</a>

You need first get the LINQ queries on your .net code, create a connection to your datasource, paste the Linq code in new queries and run them. You will get the SQL Query generated from the LINQ code.

For example:

<pre><code>from e in ETUSERs
where e.LoginName.Contains("a")
orderby e.LoginName
select e
</code></pre>

SQL Results Tab:

<pre><code>-- Region Parameters
DECLARE @p0 VarChar(1000) = '%a%'
-- EndRegion
SELECT [t0].[UserID], [t0].[UsrFirstName], [t0].[UsrLastName], [t0].[LoginName], [t0].[Location], [t0].[Password], [t0].[UsrEmail], ...
FROM [ETUSER] AS [t0]
WHERE [t0].[LoginName] LIKE @p0
ORDER BY [t0].[LoginName]
</code></pre>

This is probably not exactly what you are looking for, but it is worth knowing about this tool since it is very helpful to quickly test LINQ queries. There you can quickly edit and run to improve the code without recompiling the whole stuff.

blocks|key|4802519|text|我不认为您可以轻松地修改生成的SQL，但您可以做的是在将查询发送到数据库之前获取生成的SQL。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4802520|因此您可以将每个查询记录在一个单独的文本文件中，其中包含时间戳和源代码上下文信息。但这意味着修改源中将LINQ查询发送到数据库的每个位置。也许在DataContext类中的某个地方有一个扩展点来简化这一点。|4802521|无论如何，下面是为LINQ查询获取相应sql查询的代码：|4802522|YourDataContext+dc+=+new+YourDataContext();
IQueryable<YourEntityClass>+query+=
++++from+e+in+dc.YourEntities
++++where+...
++++select+e;

string+command+=+dc.GetCommand(query).CommandText;|code-block|syntax|javascript|4802523|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I don't think you can modify the generated SQL easily but what you can do is to get the generated SQL before sending the query to the database.

So you can log every query in a separate textfile with timestamp and source code context information. But that means to modify each place in your source where LINQ queries are sent to the database. Maybe there is an extension point somewhere in the DataContext class for simplifying this.

Anyway here is the code to get the corresponding sql query for a LINQ query:

<pre><code>YourDataContext dc = new YourDataContext();
IQueryable&lt;YourEntityClass&gt; query =
 from e in dc.YourEntities
 where ...
 select e;

string command = dc.GetCommand(query).CommandText;
</code></pre>

I am a SQL Server DBA for a company that sells an ASP.NET MVC3 application that uses LINQ and Entity Framework 4 for all database access. When I find an inefficient query in my SQL Server's plan cache that was generated by LINQ, I would like to be able to find that LINQ statement in the source code so that I can optimize it. What is the best way to find the LINQ that generated a given SQL statement?

For example, is there any way to put an entry in a config file or decorate the code somehow so that the class and method name or the LINQ statement itself are included as comments in the generated SQL?

What is the easiest way to find the LINQ statement for a SQL statement

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我是一家公司的SQL Server数据库管理员，该公司销售的ASP.NET MVC3应用程序使用LINQ和Entity Framework4进行所有数据库访问。当我在SQL Server的计划缓存中发现由LINQ生成的低效查询时，我希望能够在源代码中找到该LINQ语句，以便对其进行优化。查找生成给定SQL语句的LINQ的最佳方法是什么？例如，有没有办法在配置文件中添加一个条目，或者以某种方式修饰代

问查找SQL语句的LINQ语句的最简单方法是什么
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问查找SQL语句的LINQ语句的最简单方法是什么EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问查找SQL语句的LINQ语句的最简单方法是什么
EN