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?

Need Your Help

Cannot make a regexp work with integer numbers

c# regex

The following regexp works well with float numbers: