Linq to Entity Framework 4 query counting but not returning results
I have a query like:
var fooQuery = (from x in edm.stuff where x.col == DesiredVal select x)
'stuff' is a view. When I count the results I get '1'. When I First() or FirstOrDefault() I get null.
var fooCount = fooQuery.Count(); // results in 1 var fooResult = fooQuery.FirstOrDefault(); // results in null
This doesn't make sense to me. Is there a circumstance that this should be happening?
are you using a private member in the where statement?