Search code examples
.netentity-frameworkcachingentity-framework-4identity-map

How to invalidate entity framework 4 internal cache


As I know Entity Framework implements the Identity Map Pattern, so EF caches some entities in the memory.

Let I give you example.

var context = new StudentContext();

var student = context.Students.Where(st => st.Id == 34).FirstOrDefault();

// any way of changing student in DB
var anotherContext = new StudentContext();
var anotherStudent = anotherContext.Students.Where(st => st.Id == 34).FirstOrDefault();
anotherStudent.Name = "John Smith";
anotherContext.SaveChanges();

student = context.Students.Where(st => st.Id == 34).FirstOrDefault();
// student.Name contains old value   

Is there a way to invalidate first context's cache and retrieve new student entity without recreating context?

Thanks for help.


Solution

  • You must force EF to reload the entity. You can either do that per entity:

    context.Refresh(RefreshMode.StoreWins, student);
    

    or you can do it for query:

    ObjectQuery<Student> query = (ObjectQuery<Student>)context.Students.Where(st => st.Id == 34);
    query.MergeOption = MergeOption.OverwriteChanges;
    student = query.FirstOrDefault();
    

    or change it globally on object set:

    context.Students.MergeOption = MergeOption.OverwriteChanges;