Linq to Entity Framwork 4 query counting but not returing results.

Question

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?

Answer 1

are you using a private member in the where statement?

Answer 2

Try not to put parenthesis.