IT:AD:EF:HowTo:Second Level Caching

Summary

A slightly surprising fact about EF is that even if it has already retrieved a record, if you query it again, it will contact the db and retrieve it again (there is no caching going on).

It's only in the way it decides to update or discard the in-memory object that can be changed. The default behaviour is to compare on id (to make it sure it's already in mem) and discard it if it is – with any changes that may have already been applied, and just been retrieved….

Process

If you are stuck with only one server, and need the boost – I'd highly question the decision though – you could consider: