LINQ to SQL 不返回数据，但生成的 SQL 语句会返回数据

发布于 2024-09-02 16:24:09 字数 568 浏览 4 评论 0原文

我有一个 LINQ to SQL 查询，执行时不会返回任何数据。但是，当我调试时，我可以获取生成的 SQL 查询，插入变量的值，然后在 SQL Management Studio 中运行它以获得我期望的记录。我也在调试模式下获取变量的值。

以前有人经历过这样的事情吗？

根据要求，LINQ 语句（编辑表和列名称）：

var q1 = from rr in db.ABC
         from rd in db.DEF
         where rr.a == rd.b
         where rr.c == rd.c
         where rr.d.Equals(id)
         where rr.c.Equals(anotherId)
         select new
         {
             rr.d, rr.x, rr.a, 
             rr.y, rr.z, rr.v, 
             rr.e, rd.r
         };

var r1 = q1.Single();

我在其他地方成功地使用了非常类似的查询。

原文

I have a LINQ to SQL query that when executed does not return any data. However, when I debug, I can take the generated SQL query, plug in the values for the variables, and run it in SQL Management Studio to get the record I'm expecting. I'm taking the values for the variables while in debug mode as well.

Has anyone experienced something like this before?

As requested, LINQ statement (edited table and column names):

var q1 = from rr in db.ABC
         from rd in db.DEF
         where rr.a == rd.b
         where rr.c == rd.c
         where rr.d.Equals(id)
         where rr.c.Equals(anotherId)
         select new
         {
             rr.d, rr.x, rr.a, 
             rr.y, rr.z, rr.v, 
             rr.e, rd.r
         };

var r1 = q1.Single();

I'm using very similar queries in other places with success.

分享到QQ

分享到微博