ASP.NET MVC – Attaching an entity of type ‘MODELNAME’ failed because another entity of the same type already has the same primary key value

by

Problem SOLVED!

Attach method could potentially help somebody but it wouldn’t help in this situation as the document was already being tracked while being loaded in Edit GET controller function. Attach would throw exactly the same error.

The issue I encounter here was caused by function canUserAccessA() which loads the A entity before updating the state of object a. This was screwing up the tracked entity and it was changing state of a object to Detached.

The solution was to amend canUserAccessA() so that the object I was loading wouldn’t be tracked. Function AsNoTracking() should be called while querying the context.

// User -> Receipt validation
private bool canUserAccessA(int aID)
{
    int userID = WebSecurity.GetUserId(User.Identity.Name);
    int aFound = db.Model.AsNoTracking().Where(x => x.aID == aID && x.UserID==userID).Count();

    return (aFound > 0); //if aFound > 0, then return true, else return false.
}

For some reason I couldnt use .Find(aID) with AsNoTracking() but it doesn’t really matter as I could achieve the same by changing the query.

Hope this will help anybody with similar problem!

More Related Contents:

  1. Why does the EF 6 tutorial use asynchronous calls?
  2. How to add/update child entities when updating a parent entity in EF
  3. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  4. Filter/Search using Multiple Fields – ASP.NET MVC
  5. Non-static method requires a target
  6. Using Asp.Net Identity DataBase first approach
  7. Implementing Audit Log / Change History with MVC & Entity Framework
  8. How to do a Bulk Insert — Linq to Entities
  9. How to group by on 2 child entities and get total of both this child entities?
  10. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  11. When should I create a new DbContext()
  12. Questions about Entity Framework Context Lifetime
  13. The operation cannot be completed because the DbContext has been disposed using MVC 4
  14. Is Deferred Execution in Asp.net MVC View a very bad thing?
  15. Entity vs Model vs View Model
  16. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  17. Export Model to DataTable
  18. C# Entity-Framework: How can I combine a .Find and .Include on a Model Object?
  19. How to I apply filter while paginating in Asp.net MVC and entity Framework?
  20. Set database timeout in Entity Framework
  21. Only primitive types or enumeration types are supported in this context
  22. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  23. Keyword Not Supported: Metadata
  24. Entities VS Domain Models VS View Models
  25. How to create custom additional fields in UserProfile in MVC4
  26. How should I set up my integration tests to use a test database with Entity Framework?
  27. Where to convert business model to view model?
  28. Repository Pattern, POCO, and Business Entities
  29. MVC 4 – Many-to-Many relation and checkboxes
  30. .NET Managing Layers Relationships

Leave a Comment