How to update ALL the dirty entities from the data store, and reset their changed values to the original store value?
The method ObjectContext.Refresh requires as a parameter the entities to be refreshed.
Asked
Active
Viewed 2.9k times
4 Answers
16
The following usually works:
Context.Refresh(RefreshMode.StoreWins, _
Context.ObjectStateManager.GetObjectStateEntries())
It sometimes causes problems with EntityRelations. look at my comment for further details.
Shimmy Weitzhandler
- 101,809
- 122
- 424
- 632
-
This just saved me many lines of code walking the object graph myself. – Daniel Brückner Nov 18 '09 at 15:42
-
There is a bug, please take a look: http://stackoverflow.com/questions/1757872/undelete-an-entity-marked-as-entitystate-delete – Shimmy Weitzhandler Nov 22 '09 at 09:39
-
Sometimes you'd like to update even the unchanged items, cuz you want to refresh them against the changes made in database by other clients. – Shimmy Weitzhandler Nov 26 '09 at 02:05
-
@Shimmy `GetObjectStateEntries()` requires a parameter (e.g. Modified), and when I pass one in I get an exception that the entity is disconnected from the context. Any ideas? – Sam Selikoff Jan 13 '14 at 15:13
11
You can use this code:
public void RefreshAll()
{
// Get all objects in statemanager with entityKey
// (context.Refresh will throw an exception otherwise)
var refreshableObjects = (from entry in context.ObjectStateManager.GetObjectStateEntries(
EntityState.Deleted
| EntityState.Modified
| EntityState.Unchanged)
where entry.EntityKey != null
select entry.Entity);
context.Refresh(RefreshMode.StoreWins, refreshableObjects);
}
I wrote a post on how to RefreshAll() and refresh the context in some other ways:
Christian Rodriguez
- 944
- 1
- 9
- 20
-
This will throw an exception if you have added items. Add this before to fix: `var addedEntries = context.ObjectStateManager.GetObjectStateEntries(EntityState.Added).ToList(); addedEntries.ForEach(entry => entry.Delete());` – AncientSyntax Mar 06 '15 at 14:43
-
@AncientSyntax You are right about the exception. Actually if you think about is it doesn't make sense to try to refresh a just added entity. I've edited the response removing the EntityState.Added from the code. In your proposed solution you are actually deleting the just added entity, so nothing will be added. – Christian Rodriguez Jul 20 '15 at 11:33
-
Is this related to SQL Version, so it works when running on a 12.0 SQL server but 11.0 ? – jcubero Mar 30 '16 at 19:07
0
If you want to reset ALL the changes, you could set the ObjectContext to null and re-instantiate it.
I believe this will achieve what you want.
Kindness,
Dan
Daniel Elliott
- 22,647
- 10
- 64
- 82
-
3I guess you work with ASP.NET, so it's easy for you to say it, I use a long life-cycle context instance. – Shimmy Weitzhandler Oct 07 '10 at 10:09
0
We use this:
return Context.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Deleted
System.Data.EntityState.Modified).All(ose
=> {
if(ose.Entity != null)
Context.Refresh(RefreshMode.StoreWins, ose.Entity);
return true;
});
Where "Context" is the context to refresh. We filter by change state and entities to avoid new entities and relations.
Konrad Viltersten
- 36,151
- 76
- 250
- 438
GBrian
- 1