Entity Framework 4.1 DbSet Reload

by

This is not the way you are supposed to use DbContext, and because of that it is almost impossible to reload the data. Keeping a single context around for a long time is incorrect usage. The link will also answer why your tracked entities are not updated.

You can selectively reload a single entity by calling Reload on DbEntityEntry:

context.Entry(entity).Reload();

You can also revert back to ObjectContext and use ObjectQuery with MergeOption.OverrideChanges, or use Refresh for a collection of entities with RefreshMode.StoreWins.

All these approaches suffers some problems:

  • If the record is deleted in the database, it will not be removed from the context.
  • Changes in relations are not always refreshed.

The only correct way to get fresh data is Dispose the context, create a new one and load everything from scratch – and you are doing this anyway.

More Related Contents:

  1. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details [duplicate]
  2. Entity Framework Code First – two Foreign Keys from same table
  3. Unique key with EF code first
  4. Ignoring a class property in Entity Framework 4.1 Code First
  5. Entity Framework Join 3 Tables
  6. Is DbContext thread safe?
  7. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  8. How to retrieve Data Annotations from code? (programmatically)
  9. Why is inserting entities in EF 4.1 so slow compared to ObjectContext?
  10. EF Code First: How to get random rows
  11. Generic Way to Check If Entity Exists In Entity Framework?
  12. Overriding SaveChanges and setting ModifiedDate, but how do I set ModifiedBy?
  13. EF Code First – how to set identity seed?
  14. Can you create sql views / stored procedure using Entity Framework 4.1 Code first approach
  15. Can a DbContext enforce a filter policy?
  16. Entity Framework 4.1 InverseProperty Attribute
  17. How to configure many to many relationship using entity framework fluent API
  18. Entity Framework 4.1 InverseProperty Attribute and ForeignKey
  19. Navigation Property without Declaring Foreign Key
  20. Better way to query a page of data and get total count in entity framework 4.1?
  21. An error occurred while saving entities that do not expose foreign key properties for their relationships
  22. Can you get the DbContext from a DbSet?
  23. Entity Framework Code First Date field creation
  24. What is the difference between IDbSet.Add and DbEntityEntry.State = EntityState.Added?
  25. DbSet table name
  26. mapping multiple tables to a single entity class in entity framework
  27. Create association on non-primary key fields with Entity Framework 4.1 Fluent API
  28. linq syntax: What is the type that this returns? How can I now go ahead and use firstRow.ingredientName etc?
  29. Playing a MP3 file in a WinForm application
  30. Listen to changes of dependency property

Leave a Comment