How Can I Refresh My Context Of Entity Framework

Question

4.00/5 (1 vote)

See more:

Hello everyone,

I have a small program (multi user).

When I run 2 sessions of my program and in session 1 I do an update of the data, I can't see the updated data in session 2. However the updated data is stored correctly in the database.

When I do an insert in session 1, I see the insert in session 2.

My plan was to do a refresh of the context, but this doesn't seems to be possible.

Has anyone the same problem and a simple solution?

Many thanks in advance!

Posted 31-May-14 3:17am

aanbidmij

Add a Solution

3 solutions

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)

Raul Iloc · Answer 1 · 2014-05-31T03:32:00

Solution 2

You could refresh only the needed data set by using:

this.MyObjectContext.Refresh(RefreshMode.StoreWins, this.MyObjectContext.MyObjectSet);<br />

But I recommend to use the advises from Solution1 and to use the method above only when you realy need it!

Posted 31-May-14 3:32am

Raul Iloc

Updated 31-May-14 3:35am

v2

Comments

aanbidmij 1-Jun-14 4:17am

In my program I use the class Context not ObjectContext... apperantly in the class Context the method .Refresh(...,...) doesn't exist

Dave Kreskowiak · Answer 2 · 2014-05-31T03:23:00

Solution 1

If you're creating an instance of the context and keeping it alive for the lifetime of the application, you're doing it wrong.

Create a context when you need to do a query and Dispose it when you're done. This way, you don't have to "refresh" it. It'll pickup the new data when ever you do your next query for it.

Posted 31-May-14 3:23am

Dave Kreskowiak

Comments

aanbidmij 31-May-14 10:32am

That was what i tought at first. I have changed my code I use a generic repository and have declared my context like this => static Context cts = new Context(); but i still have the same problem

DamithSL · Answer 3 · 2014-05-31T03:39:00

you can use Refresh method of the context or dispose the old context and create again. But if you need to refresh only when the context change and it need to be happen automatically whenever database changed. Then you can try below article with SQL Server Service Broker.
AutoRefresh Entity Framework Data Using SQL Server Service Broker[^]