Manually delete object tree in entity-Framework

Question

If I want to delete manually an object and all it's children, How can I do it (I don't want to use cascade-delete)

When I'm trying to iterate over the children list - I get an exception because I'm changing the collection inside foreach - and that's a problem... any other way to do it ? (I'm setting each time state to deleted).

var myAssignemnt = (from s in context.Assignments.Include("ActivityInAssignments").Where(s => s.AssignmentID == AssignmentID) select s).FirstOrDefault();

foreach (ActivityInAssignment acc in myAssignemnt.ActivityInAssignments)
{
  context.ObjectStateManager.ChangeObjectState(acc, System.Data.EntityState.Deleted);
}
context.ObjectStateManager.ChangeObjectState(myAssignemnt, System.Data.EntityState.Deleted);
context.SaveChanges();

Henk Holterman · Accepted Answer · 2011-01-29 18:56:25Z

2

Maybe try ... in myAssignemnt.ActivityInAssignments.ToList()

answered Jan 29, 2011 at 18:56

Henk Holterman

276k33 gold badges353 silver badges540 bronze badges

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

2 Comments

Dani Over a year ago

can you explain why it works with ToList() and not original collection ? (I though the problem is in the foreach function and not inside the ActivityInAssignment collection.

Henk Holterman Over a year ago

The problem is in the collection, It reacts to items being 'removed' and that invalidates the foreach. ToList makes a copy of the references and that copy is immune to the changes.

Collectives™ on Stack Overflow

Manually delete object tree in entity-Framework

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related