Is there a significant difference between
.Where(x = >x.Id == id) that should compel me to use
I would imagine that
.Find() would be more efficient but is it so much more efficient that I should avoid
The reason I ask is that I am using a generic FakeDbSet in my tests to make it easy to implement fake results and so far I have found that I must inherit that class and provide a custom implementation of
.Find() whereas if I write my code with
.Where()/.First() I don't need to do that extra work.
The point is that
find starts by searching in the local cache of the context and then, if no match, sends a query to the db.
where always sends a query to the db.
With EF 4.*, I used to think that sql generated by
find was too complex and, in some cases, leads to a performance issue. So I always use
where even with EF 5. I should check the sql generated by
find with EF 5.
So in the paper,
find is better because he uses the cache.