Insert List of Objects using Entity Framework

Question

Hi i am trying to attach multiple objects in ObjectContextManager and try to set their state in "Added" Mode. These objects have some navigational properties with them and when i try to attach any object after attaching the first object. It throws me the error

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

The reason seems to be very obvious but what will be its solution.

Kindly guide

Ladislav Mrnka · Accepted Answer · 2012-07-11 08:34:30Z

1

By calling Attach or AddObject on the entity you are actually attaching or adding whole object graph (EF traverse navigation properties and executes the operation on every related property). When you try to add or attach entity which was already attached or added as part of object graph you will get this exception. The solution is to understand your data model and call AddObject or Attach only for disjointed object graphs.

answered Jul 11, 2012 at 8:34

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jehof · Accepted Answer · 2012-07-12 05:30:36Z

0

You should initialize the Id of new entities you add/attach with a random Id (like Guid.NewGuid().GetHashCode() if you use Int32 as Id-type)

Otherwise have all entities the default Id of 0, and so will the ObjectStateManager throw an exception when you attach the entities.

edited Jul 12, 2012 at 5:30

answered Jul 11, 2012 at 7:07

Jehof

35.7k11 gold badges129 silver badges156 bronze badges

Collectives™ on Stack Overflow

Insert List of Objects using Entity Framework

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related