Delete child objects in Entity Framework

Question

I'm using EF and when I do this:

            foreach (var reg in detail.Regs)
            {
                this.db.Regs.DeleteObject(reg);
            }

I get this:

Collection was modified; enumeration operation may not execute.

What I'm I doing wrong here???

Morteza Manavi · Accepted Answer · 2010-11-11 03:15:28Z

80

The reason for that is because as you delete the objects from the context, EF is actively update the Regs navigation property count which means the detail.Regs collection is being changed during the foreach loop which always cause the exception you are getting.

You can create a new collection object and keep deleting from it like this:

foreach (var reg in detail.Regs.ToList())
{
    this.db.Regs.DeleteObject(reg);
}

Or even you can make it cleaner by using LINQ ForEach method:

detail.Regs.ToList().ForEach(r => db.Regs.DeleteObject(r));

answered Nov 11, 2010 at 3:15

Morteza Manavi

33.2k6 gold badges103 silver badges84 bronze badges

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

1 Comment

MeTitus Over a year ago

That get all the records from the database just to have them deleted no?

Collectives™ on Stack Overflow

Delete child objects in Entity Framework

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related