How to clear or ignore all entity framework cache one time ?

Question

0.00/5 (No votes)

See more:

hi,

I write a software ( huge software about 200 form which works on a network ), every form have Many queries.

now I need to clear EF6 cache. I need to load data from database, not context cache.

what is the easy and time-saving way to clear this cache? there is any method to apply it to all over EF one time without repeating it in all forms?

What I have tried:

i searched and found these methods but all of them Not suitable for applied once and difficult to carry out many times.

Disable Tracking using AsNoTracking()
Throw away the DbContext and create a new one
Use an ObjectQuery instead of a DBQuery and set MergeOptions
Refresh the Entities
Detach the Entities
Call GetDatabaseValues to get the updated values for a single Entity

Posted 30-Apr-18 16:13pm

Golden Basim

Updated 30-Apr-18 18:49pm

Add a Solution

2 solutions

Solution 2

While "Dispose and create new" is generally the best advice, there are edge cases. For example, if a method is going to be doing *alot* of work, but that method is getting a context passed to it, and is incapable of creating a new context (it does not have sufficient information). BEing able to "flush" specific DbSets (and handle side effects) would be a powerful feature...

Posted 3-Oct-22 3:49am

TheCPUWizard

Updated 3-Oct-22 3:51am

Comments

Richard Deeming 3-Oct-22 11:43am

That may be the case; but your comment is not a solution to this already-solved question, and is definitely not a reason to resurrect a thread from four years ago!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2018-04-30T18:50:00

Solution 1

This question makes me wonder how you're creating a DbContext instance and using it. To "clear the cache" is to just Dispose the context instance and create another one.

You most certainly should NOT create a DbContext instance and just hold onto it for the lifetime of your application.

Posted 30-Apr-18 18:50pm

Dave Kreskowiak