公开 LINQ 执行时触发的 SQL

发布于 2024-09-17 19:55:43 字数 574 浏览 1 评论 0原文

大家早上好。

为您简单介绍一下 - 在哪里可以找到 LINQ 语句触发时执行的 SQL？

我有以下代码，可以正常工作，

 var r = (from p in getproductweightsbuyer.tblWeights
                     where p.MemberId == memberid &&
                              p.LocationId == locationid
                     select p);

            if (buyer != "Not Specified")
                r = r.Where(p => p.UnitUserField1 == buyer);

            if (subcategory != "Not Specified")
                r = r.Where(p => p.UnitUserField2 == subcategory);

我只是不确定在条件 where 子句中触发的 SQL。

原文

Morning all.

Just a quick one for you - where can I find the SQL that is executed when a LINQ statement fires?

I have the following code that works a treat,

 var r = (from p in getproductweightsbuyer.tblWeights
                     where p.MemberId == memberid &&
                              p.LocationId == locationid
                     select p);

            if (buyer != "Not Specified")
                r = r.Where(p => p.UnitUserField1 == buyer);

            if (subcategory != "Not Specified")
                r = r.Where(p => p.UnitUserField2 == subcategory);

I'm just not sure of the SQL that is firing in the conditional where clause.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

撩起发的微风 2024-09-24 19:55:43

如果您手头有数据库上下文，您可以尝试：

context.GetCommand(query).CommandText

If you have the database context at hand you could try:

context.GetCommand(query).CommandText

回复收藏 0 原文

不必你懂 2024-09-24 19:55:43

如果您调试代码，您可以放置一个断点并分析 r 的值，其中将包含实际的 SQL 代码。

回复收藏 0 原文

岁月无声 2024-09-24 19:55:43

除了上述选项之外，您还可以运行 SQL 分析器并查看通过线路发送到数据库的实际 SQL。

回复收藏 0 原文

垂暮老矣 2024-09-24 19:55:43

如果您使用 LINQ to SQL，则可以设置 DataContext.Log 属性。当您执行查询时，这将记录 SQL：

getproductweightsbuyer.Log = Console.Out;

var r = (from p in getproductweightsbuyer.tblWeights
                    where p.MemberId == memberid &&
                             p.LocationId == locationid
                    select p);

           if (buyer != "Not Specified")
               r = r.Where(p => p.UnitUserField1 == buyer);

           if (subcategory != "Not Specified")
               r = r.Where(p => p.UnitUserField2 == subcategory);

foreach (var row in r)
  ...

If you use LINQ to SQL you can set the DataContext.Log property. This will log the SQL when you execute the query:

getproductweightsbuyer.Log = Console.Out;

var r = (from p in getproductweightsbuyer.tblWeights
                    where p.MemberId == memberid &&
                             p.LocationId == locationid
                    select p);

           if (buyer != "Not Specified")
               r = r.Where(p => p.UnitUserField1 == buyer);

           if (subcategory != "Not Specified")
               r = r.Where(p => p.UnitUserField2 == subcategory);

foreach (var row in r)
  ...

回复收藏 0 原文

~没有更多了~