DbContext discard changes without disposing

by 
public void RejectChanges()
    {
        foreach (var entry in ChangeTracker.Entries())
        {
            switch (entry.State)
            {
                case EntityState.Modified:
                case EntityState.Deleted:
                    entry.State = EntityState.Modified; //Revert changes made to deleted entity.
                    entry.State = EntityState.Unchanged;
                    break;
                case EntityState.Added:
                    entry.State = EntityState.Detached;
                    break;
            }
        }
    }

Update:

Some users suggest to add .ToList() to avoid ‘collection was modified’ exception.
But I believe there is a reason for this exception.

How do you get this exception? Probably, you are using context in non threadsafe manner.

More Related Contents:

  1. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  2. Ignoring a class property in Entity Framework 4.1 Code First
  3. What difference does .AsNoTracking() make?
  4. What is the purpose of self tracking entities?
  5. The entity type is not part of the model for the current context
  6. LINQ to Entities does not recognize the method ‘Double Parse(System.String)’ method, and this method cannot be translated into a store expression
  7. Unable to update the EntitySet – because it has a DefiningQuery and no element exist
  8. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  9. Entity Framework – Code First – Can’t Store List
  10. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  11. Entity Framework/Linq EXpression converting from string to int
  12. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  13. linq to entities doesn’t recognize a method
  14. How to convert an expression tree to a partial SQL query?
  15. Enable Migrations with Context in Separate Assembly?
  16. Entity Framework – Cannot convert lambda expression to type ‘string’ because it is not a delegate type
  17. Internal .NET Framework Data Provider error 1025
  18. Include with FromSqlRaw and stored procedure in EF Core 3.1
  19. How to filter data using Entity Framework in a way that DataGridView be editable and context track changes?
  20. How can I disable model compatibility checking in Entity Framework 4.3?
  21. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  22. Entity Framework Code Only error: the model backing the context has changed since the database was created
  23. How to compare only Date without Time in DateTime types?
  24. Set database timeout in Entity Framework
  25. Global setting for AsNoTracking()?
  26. EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata
  27. Remove item from list based on condition
  28. Change db table name in EF4 (entity framework 4)
  29. Repository Pattern, POCO, and Business Entities
  30. Net Core: Using OData in Onion Architecture, Convert Query Parameters Into Linq

Leave a Comment