优化 LINQ to SQL 查询的工具和技术

问题描述

我有几个 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:

1. 他们需要多长时间，如果有改进的空间?
2. 找出我可以改变什么并轻松测试那些更改是否有效?

1. How long they take and if there is room for improvement?
2. Find out what I can change and easily test if those changes are effective?

工具、技术和阅读资源都将受到赞赏(ergo upvoted ;))

Both tools, techniques and reading resources would be appreciated (ergo up-voted ;))

推荐答案

我刚刚参加了 LINQ 实战.他在博客上介绍了所有工具.以下是与您的问题相关的问题，但他的帖子列出了其他值得研究的好东西.

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 to 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 查询的工具和技术的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持html5模板网！