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

asp.net-mvc-3 entity-framework

Question

I have following code to add or update the Entity object. finding the object by primary key, based on the response I am adding or updating the object.

Adding record works, but during update its giving this error message "An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key"

In my MSSQL database I have only one record.

var v = db.Envelopes.Find(model.ReportDate, model.Service);
if (v == null)
{
    db.Envelopes.Add(model);
    db.SaveChanges();
    ViewBag.status = "Record Add successfully";
    ModelState.Clear();
}
else
{
    db.Entry(model).State = EntityState.Modified;
    db.SaveChanges();
}

How can I fix this error message?

1
52
9/7/2012 5:49:05 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

As mentioned by @anon you can't attach model once you loaded the entity with the same key. The changes must be applied to attached entity. Instead of this:

db.Entry(model).State = EntityState.Modified;

use this: 

db.Entry(v).CurrentValues.SetValues(model);
88
4/15/2011 7:40:17 AM

Popular Answer

If an earlier query read the entity to be updated and that's why you're getting the error, you can change that query to AsNoTracking. See the AsNoTracking example in: http://www.asp.net/entity-framework/tutorials/advanced-entity-framework-scenarios-for-an-mvc-web-application

tdykstra

Related Questions

Error: The object cannot be deleted because it was not found in the ObjectStateManager

Each EF object is tightly associated to the manager (for want of a better word) that created it. or to which it has been associated. Since you don't pass ...db... to your ...Get... method, I assume that ...Get... has either used it's own ...J1Entities..., or the object has been created standalone (perhaps deserialized)....In order to delete it, it ...
c# entity-framework linq-to-entities
asked by Marc Gravell

An object with the same key already exists in the ObjectStateManager. The existing object is in the Unchanged state

i'm using this because I have already created a new instance, and populated the properties I need to update....Public Sub Insert(ByVal _lstFoo As List(Of TB_FOO)) Try For i As Integer = 0 To _lstFoo.Count - 1 Dim foo As TB_FOO = _lstFoo(i) ObjectStateEntry ose; Dim key=CreateEntityKey("TB_FOOs",foo); if(ObjectStateManager.Try...
.net entity-framework
asked by Maslow

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

Just a bit of help for you if you don't know how to find the ...oldEntity... as according to Ladislav:...var entityKey = context.NewEntitySet.Create().GetType().GetProperty("Id").GetValue(newEntity); factory.Entry(context.Set<NewEntityType>().Find(entityKey)).CurrentValues.SetValues(newEntity);
entity-framework
asked by Serj Sagan

The object cannot be deleted because it was not found in the ObjectStateManager

You could just "Attach" the object to the current context like that:...public void Delete(T entity) { context.AttachTo(entity.EntityKey.EntitySetName, entity); Context.DeleteObject(entity); Context.SaveChanges(); }
asp.net-mvc entity-framework
asked by Gili

Entity Framework Code-First: "The ObjectStateManager cannot track multiple objects with the same key."

The problem is that this query...string thisQueryWillMessThingsUp = context.SaleMethods.Where(m => m.Id == 2).Single().Name; ...brings one instance of the SaleMethod entity into the context and then this code...context.Entry(method).State = System.Data.EntityState.Modified; ...attaches ...a different instance... to the context. Both instance...
asp.net-mvc-3 code-first dbcontext entity-framework repository
asked by Arthur Vickers

The object cannot be deleted because it was not found in the ObjectStateManager?

You get this error if the object you are trying to delete isnt attached to the current context. To get attached objects you either need to query the object from the db on the context, or manually call attach (before delete) to put the object onto the context.
c#-4.0 entity-framework
asked by Not loved

The ObjectStateManager cannot track multiple objects with the same key

there are multiple problems;...Do not call ...GetAll()... if you want to fetch a single entity, what if you have thousands of entities in the database. Just implement a SingleOrDefault in the repository....Use :...User testUser = userRepository.FirstOrDefault(x => x.Name.Equals(user.Name));...instead of :...User testUser = userRepository.GetAll().F...
c# entity-framework
asked by daryal

The object cannot be deleted because it was not found in the ObjectStateManager

The other answer didn't work, so here's how I fixed it....Previously I had:...public void ok(myTable myCurrent) { //delete entries from other tables in relationship with myTable db.myTables.DeleteObject(myCurrent); } ...I fixed it with this:...public void ok(int current_id) { //delete entries from other tables in relationship with myTa...
.net c# entity-framework
asked by petko_stankoski

Entity Framework: An object with the same key already exists in the objectstatemanager

This is due to inproper disposal of the database context, as you are never disposing of the context object itself you will run into these kinds of problems....I would suggest wrapping the code in a using statement.....using (var context = new MyContext()) { // Do my save code here... } ...That will ensure proper disposal of the context!
.net asp.net-mvc-3 c# entity-framework
asked by BenjaminPaul

MVC5/EF6: Object cannot be deleted because it was not found in the ObjectStateManager?

The problem is that you're actually using 2 ...DbContext... here and they cannot track each other's Entities....You have to change your Controller code to have both ...db... and ...UserManager... share the same context instance reference:...public UserManagementController() { this.db = context.Get<ApplicationDbContext>(); }
asp.net-mvc asp.net-mvc-5 c# entity-framework-6 objectstatemanager
asked by haim770

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow