blocks|key|665338|text|使用Linq2Sql|type|unstyled|depth|inlineStyleRanges|entityRanges|data|665339|dc.GetCommand(query).CommandText|code-block|syntax|javascript|665340|有关详细信息，请参阅http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.getcommand.aspx。|offset|length|665341|但我通常使用LinqPad|665342|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.getcommand.aspx|1|http://www.linqpad.net/^0|0|0|A|2C|0|0|6|7|1|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@$I|Z|J|10|1|11]]|A|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@$I|13|J|14|1|15]]|A|$]]|$1|M|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]|U|$5|P|Q|R|A|$S|V]]]]

With Linq2Sql 

<pre><code>dc.GetCommand(query).CommandText
</code></pre>

see <a href="http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.getcommand.aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.getcommand.aspx</a> for more info.

But I usually use <a href="http://www.linqpad.net/" rel="noreferrer">LinqPad</a>

blocks|key|665466|text|有3种方法可以做到这点。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|665467|1.你可以使用LINQPad.It，它是免费的http://www.linqpad.net/|offset|length|665468|2.您可以在SQL+Server中使用Sql+Server事件探查器(工具-->+SQL+Server事件探查器)|665469|3.您可以使用Visual+Studio调试器生成T-Sql。(适用于任何visual+studio版本)|665470|entityMap|0|LINK|mutability|MUTABLE|url|http://www.linqpad.net/^0|0|N|N|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

There are 3 ways do that.
1.You can use LINQPad.It's Free <a href="http://www.linqpad.net/" rel="nofollow noreferrer">http://www.linqpad.net/</a>
2.You can use SQL Server Profiler inside the Sql Server (Tools --&gt; SQL Server Profiler)
3.You can use Visual Studio Debugger for Generate T-Sql.(with any visual studio version)

blocks|key|882239|text|如果使用SQL+Server作为数据库，请使用SQL+Profiler。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|882240|entityMap^0|N|C|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Use <code>SQL Profiler</code> if you are using SQL Server as your database.

blocks|key|882283|text|这是在Google上弹出的，这是一个8部分的教程。我想它会让你忙上几个小时，在我看来它是相当详细的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|882284|1：http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx|offset|length|882285|2：http://weblogs.asp.net/scottgu/archive/2007/05/29/linq-to-sql-part-2-defining-our-data-model-classes.aspx|882286|3：http://weblogs.asp.net/scottgu/archive/2007/06/29/linq-to-sql-part-3-querying-our-database.aspx|882287|4：http://weblogs.asp.net/scottgu/archive/2007/07/11/linq-to-sql-part-4-updating-our-database.aspx|882288|5：http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx|882289|6：http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx|882290|7：http://weblogs.asp.net/scottgu/archive/2007/08/23/linq-to-sql-part-7-updating-our-database-using-stored-procedures.aspx|882291|8：http://weblogs.asp.net/scottgu/archive/2007/08/27/linq-to-sql-part-8-executing-custom-sql-expressions.aspx|882292|祝好运。|882293|entityMap|0|LINK|mutability|MUTABLE|url|http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx|1|http://weblogs.asp.net/scottgu/archive/2007/05/29/linq-to-sql-part-2-defining-our-data-model-classes.aspx|2|http://weblogs.asp.net/scottgu/archive/2007/06/29/linq-to-sql-part-3-querying-our-database.aspx|3|http://weblogs.asp.net/scottgu/archive/2007/07/11/linq-to-sql-part-4-updating-our-database.aspx|4|http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx|5|http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx|6|http://weblogs.asp.net/scottgu/archive/2007/08/23/linq-to-sql-part-7-updating-our-database-using-stored-procedures.aspx|7|http://weblogs.asp.net/scottgu/archive/2007/08/27/linq-to-sql-part-8-executing-custom-sql-expressions.aspx^0|0|2|27|0|0|2|2X|1|0|2|2N|2|0|2|2N|3|0|2|3D|4|0|2|35|5|0|2|3B|6|0|2|2Y|7|0|0^^$0|@$1|2|3|4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1I|8|@]|9|@$D|1J|E|1K|1|1L]]|A|$]]|$1|F|3|G|5|6|7|1M|8|@]|9|@$D|1N|E|1O|1|1P]]|A|$]]|$1|H|3|I|5|6|7|1Q|8|@]|9|@$D|1R|E|1S|1|1T]]|A|$]]|$1|J|3|K|5|6|7|1U|8|@]|9|@$D|1V|E|1W|1|1X]]|A|$]]|$1|L|3|M|5|6|7|1Y|8|@]|9|@$D|1Z|E|20|1|21]]|A|$]]|$1|N|3|O|5|6|7|22|8|@]|9|@$D|23|E|24|1|25]]|A|$]]|$1|P|3|Q|5|6|7|26|8|@]|9|@$D|27|E|28|1|29]]|A|$]]|$1|R|3|S|5|6|7|2A|8|@]|9|@$D|2B|E|2C|1|2D]]|A|$]]|$1|T|3|U|5|6|7|2E|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|2F|8|@]|9|@]|A|$]]]|W|$X|$5|Y|Z|10|A|$11|12]]|13|$5|Y|Z|10|A|$11|14]]|15|$5|Y|Z|10|A|$11|16]]|17|$5|Y|Z|10|A|$11|18]]|19|$5|Y|Z|10|A|$11|1A]]|1B|$5|Y|Z|10|A|$11|1C]]|1D|$5|Y|Z|10|A|$11|1E]]|1F|$5|Y|Z|10|A|$11|1G]]]]

This popped up on Google, it's an 8-part tutorial. I think it will keep you busy for a few hours, it seems quite detailed to me.

1: <a href="http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx" rel="nofollow">http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx</a>

2: <a href="http://weblogs.asp.net/scottgu/archive/2007/05/29/linq-to-sql-part-2-defining-our-data-model-classes.aspx" rel="nofollow">http://weblogs.asp.net/scottgu/archive/2007/05/29/linq-to-sql-part-2-defining-our-data-model-classes.aspx</a>

3: <a href="http://weblogs.asp.net/scottgu/archive/2007/06/29/linq-to-sql-part-3-querying-our-database.aspx" rel="nofollow">http://weblogs.asp.net/scottgu/archive/2007/06/29/linq-to-sql-part-3-querying-our-database.aspx</a>

4: <a href="http://weblogs.asp.net/scottgu/archive/2007/07/11/linq-to-sql-part-4-updating-our-database.aspx" rel="nofollow">http://weblogs.asp.net/scottgu/archive/2007/07/11/linq-to-sql-part-4-updating-our-database.aspx</a>

5: <a href="http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx" rel="nofollow">http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx</a>

6: <a href="http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx" rel="nofollow">http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx</a>

7: <a href="http://weblogs.asp.net/scottgu/archive/2007/08/23/linq-to-sql-part-7-updating-our-database-using-stored-procedures.aspx" rel="nofollow">http://weblogs.asp.net/scottgu/archive/2007/08/23/linq-to-sql-part-7-updating-our-database-using-stored-procedures.aspx</a>

8: <a href="http://weblogs.asp.net/scottgu/archive/2007/08/27/linq-to-sql-part-8-executing-custom-sql-expressions.aspx" rel="nofollow">http://weblogs.asp.net/scottgu/archive/2007/08/27/linq-to-sql-part-8-executing-custom-sql-expressions.aspx</a>

Good luck.

blocks|key|665422|text|另一种方式|type|unstyled|depth|inlineStyleRanges|entityRanges|data|665423|来自MSDN文章How+to:+Display+Generated+SQL+(LINQ+to+SQL)|offset|length|665424|将DataContext.Log属性设置为Console.Out，您将在控制台中看到它|style|CODE|665425|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/bb386961.aspx|1|http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.log.aspx^0|0|8|17|0|0|1|F|L|B|1|F|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@$D|V|E|W|1|X]]|A|$]]|$1|F|3|G|5|6|7|Y|8|@$D|Z|E|10|H|I]|$D|11|E|12|H|I]]|9|@$D|13|E|14|1|15]]|A|$]]|$1|J|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]|R|$5|M|N|O|A|$P|S]]]]

Another way 

From the MSDN article <a href="http://msdn.microsoft.com/en-us/library/bb386961.aspx" rel="nofollow">How to: Display Generated SQL (LINQ to SQL)</a>

Set the <a href="http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.log.aspx" rel="nofollow"><code>DataContext.Log</code></a> Property to <code>Console.Out</code> and you'll see it in the console

blocks|key|882744|text|我能建议的最简单的方法是使用Database+Log。在初始化DataContext之后放入Log，你将能够跟踪EF在visual+studio+output窗口上所做的任何事情。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|882745|++DataContext+db+=+new+DataContext();
++db.Database.Log+=+generatedSQL+=>
+++{
++++++Debug.WriteLine(generatedSQL);
+++};|code-block|syntax|javascript|882746|entityMap^0|E|8|N|3|V|B|1A|3|21|6|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|L|$]]

The easiest way i could suggest is to go with <code>Database</code> <code>Log</code>. Put <code>Log</code>after initializing <code>DataContext</code> and you will be able to track whatever is done by EF on visual studio <code>output</code> window.

<pre><code> DataContext db = new DataContext();
 db.Database.Log = generatedSQL =&gt;
 {
 Debug.WriteLine(generatedSQL);
 };
</code></pre>

问如何从linq查询中查看生成的sql
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从linq查询中查看生成的sqlEN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从linq查询中查看生成的sql
EN