如何从 LINQ DataContext.SubmitChanges() 获取 TSQL 查询

问题描述

我正在使用 Linq to SQL.我有一个 DataContext，我正在针对它 .SubmitChanges()'ing.插入身份字段时出错，我想查看它用于插入此身份字段的查询.

I'm using Linq to SQL. I have a DataContext against which I am .SubmitChanges()'ing. There is an error inserting the identity field, and I'd like to see the query it's using to insert this identity field.

我在 quickwatch 中没有看到查询本身；我在哪里可以从调试器中找到它?

I don't see the query itself within the quickwatch; where can I find it from within the debugger?

推荐答案

其实你的问题有一个很简单的答案

There is actually a very simple answer to your question

只需将其粘贴到您的观察窗口中

Just paste this in your watch window

((System.Data.Objects.ObjectQuery)myLinqQueryVar).ToTraceString()

这篇关于如何从 LINQ DataContext.SubmitChanges() 获取 TSQL 查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持html5模板网！