How to bypass cache on a single Entity Framework 4.0 query?

Question

Is there a way in Entity Framework 4.0 to bypass the object cache for a single LINQ query?

I want to be able to execute a query and know that I'm getting the absolute latest from the database even if that object has been retrieved earlier in the request and has been stored in cache.

Ladislav Mrnka · Accepted Answer · 2012-02-28 09:49:03Z

3

You must configure your query or object set to force materialization of result set instead of using already materialized entities from identity map.

context.YourObjectSet.MergeOption = MergeOption.OverwriteChanges;
// now execute the query as many times as you want

or

var query = ...;
((ObjectQuery<YourEntity>)query).MergeOption = MergeOption.OverwriteChanges;

answered Feb 28, 2012 at 9:49

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Gert Arnold Over a year ago

+1 Good to know that. MergeOption is a somewhat unexpected name to enforce cache overrides, but ah well, it works. I was experimenting with ObjectContext.Refresh with RefreshMode.StoreWins and was baffled to see that that did not work as I expected.

Maxim Eliseev Over a year ago

It did NOT work for me (EF6.0). I could not find MergeOption property. I guess there were some breaking changes in EF. This answer was useful: stackoverflow.com/a/4911591/1131855

Ladislav Mrnka Over a year ago

@MaximEliseev: MergeOption is a feature of original ObjectContext API. You are using newer API.

Collectives™ on Stack Overflow

How to bypass cache on a single Entity Framework 4.0 query?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related