优化LINQ to SQL查询的工具和技术 [英] Tools and techniques to optimize a LINQ to SQL query
问题描述
我有几个LINQ to SQL查询，我觉得这要花很多时间.我可以使用什么工具和技术来首先找出答案:
I have a couple of LINQ to SQL queries that I feel take a lot of time. What tool and techniques can I use to first find out:
- 他们花了多长时间以及如果 有改善的空间?
- 找出我可以更改的内容，并轻松测试那些 更改是否有效?
- How long they take and if there is room for improvement?
- Find out what I can change and easily test if those changes are effective?
工具，技术和阅读资源都将不胜感激(因此，请多加投票；)
Both tools, techniques and reading resources would be appreciated (ergo up-voted ;))
推荐答案
我刚参加了在博客中介绍了所有工具.这是与您的问题有关的问题，但他的帖子列出了其他值得研究的东西.
I just attended a LINQ Tools presentation at a recent codecamp event given by Jim Wooley, one of the authors of LINQ In Action. He blogged about all the tools. Here are the ones that relate to your question, but his post lists other goodies to look into.
-
SQL Server Profiler ($$$) -SQL Management Studio的一部分.
SQL Server Profiler ($$$) - part of the SQL Management Studio.
Huagati LINQ to SQL Profiler ($$$，45天试用期) -探查器，它扩展了Context.Log功能.除了SQL Server Profiler所能提供的功能之外，还包括查询的性能和调用堆栈.
Huagati LINQ to SQL Profiler ($$$, 45-day trial) - Profiler which extends the Context.Log functionality. Includes performance and call stacks for the queries beyond what you get with SQL Server Profiler.
LINQ to SQL Visualizer (免费)-C#示例的一部分VS2008.下载，编译，享受吧！
LINQ to SQL Visualizer (free) - part of the C# Samples for VS2008. Download, compile, enjoy!
LINQPad (免费，为C#Intellisense付费)-轻量级的工具，用于运行C# /VB.NET代码，连接到数据库，测试Linq到SQL，查看生成的SQL等.
LINQPad (free, pay for C# Intellisense) - light-weight tool to run C#/VB.NET code, connect to DBs, test Linq to SQL, view the generated SQL etc.
这篇关于优化LINQ to SQL查询的工具和技术的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
