How to stop entity framework caching

Question

We're having a problem testing Entity Framework 4.

We've deployed a WCF service that implements an EF data context. All works fine untill we modify the data using SQL server studio.

Is there a way to stop EF caching our results or is there any way to turn eager loading on?

Cheers,

James

Do you mean that you load entities and they don't somehow get reloaded from the database automatically? Or do you mean that your data context doesn't fetch data from the database every time you load an object? Can you show an example of what doesn't work for you? — mlibby
– mlibby, Commented Dec 3, 2010 at 14:36
Hi, I mean that our data context doesn't fetch data from the database every time we load an object. We'd like it to, if it's possible? — Zack
– Zack, Commented Dec 3, 2010 at 14:38

Jeff Ogata · Accepted Answer · 2010-12-03 14:46:03Z

7

On the property sheet for your model, you can set the Lazy Loading Enabled property.

alt text

Through code, you can control lazy loading with the ObjectContextOptions.LazyLoadingEnabled property:

context.ContextOptions.LazyLoadingEnabled = false;

answered Dec 3, 2010 at 14:46

Jeff Ogata

58k20 gold badges117 silver badges128 bronze badges

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

Comments

Lodlaiden · Accepted Answer · 2014-01-03 00:49:39Z

4

In EF4 I had to use this instead:

_context.Configuration.LazyLoadingEnabled = false;

answered Jan 3, 2014 at 0:49

Lodlaiden

4112 silver badges10 bronze badges