An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key

by

Edit: Original answer used Find instead of Local.SingleOrDefault. It worked in combination with @Juan’s Save method but it could cause unnecessary queries to database and else part was probably never executed (executing the else part would cause exception because Find already queried the database and hadn’t found the entity so it could not be updated). Thanks to @BenSwayne for finding the issue.

You must check if an entity with the same key is already tracked by the context and modify that entity instead of attaching the current one:

public override void Update(T entity) where T : IEntity {
    if (entity == null) {
        throw new ArgumentException("Cannot add a null entity.");
    }

    var entry = _context.Entry<T>(entity);

    if (entry.State == EntityState.Detached) {
        var set = _context.Set<T>();
        T attachedEntity = set.Local.SingleOrDefault(e => e.Id == entity.Id);  // You need to have access to key

        if (attachedEntity != null) {
            var attachedEntry = _context.Entry(attachedEntity);
            attachedEntry.CurrentValues.SetValues(entity);
        } else {
            entry.State = EntityState.Modified; // This should attach entity
        }
    }
}

As you can see the main issue is that SingleOrDefault method needs to know the key to find the entity. You can create simple interface exposing the key (IEntity in my example) and implement it in all your entities you want to process this way.

More Related Contents:

  1. Entity Framework (EF) Code First Cascade Delete for One-to-Zero-or-One relationship
  2. Generic Repository or Specific Repository for each entity?
  3. Entity Framework Join 3 Tables
  4. Method cannot be translated into a store expression
  5. EF Including Other Entities (Generic Repository pattern)
  6. Non-static method requires a target
  7. Creating Composite Key Entity Framework
  8. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  9. Mapping Database Views to EF 5.0 Code First w/Migrations
  10. EF migration for changing data type of columns
  11. Using Simple Injector with Unit Of Work & Repository Pattern in Windows Form
  12. Can EF automatically delete data that is orphaned, where the parent is not deleted?
  13. get date part only from datetime value using entity framework
  14. EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata
  15. Where to convert business model to view model?
  16. Add data annotations to a class generated by entity framework
  17. Circular reference detected exception while serializing object to JSON
  18. Get return value from stored procedure
  19. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  20. Linq to EntityFramework DateTime
  21. LINQ to SQL multiple tables left outer join
  22. Entity Framework. Delete all rows in table
  23. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  24. how to create an audit trail with Entity framework 5 and MVC 4
  25. Linq to Entity Join table with multiple OR conditions
  26. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  27. Entity framework large data set, out of memory exception
  28. Parallel doesnt work with Entity Framework
  29. The relationship could not be changed because one or more of the foreign-key properties is non nullable
  30. Entity Framework Many to many through containing object

Leave a Comment