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.
