How to delete a list of objects in EF6 when the object is detached from the context

Question

OK I can delete a single item in EF6 like this:

public void DeleteUserGroup(MY_GROUPS ug)
{
    using (var context = new MYConn())
    {
        var entry = context.Entry(ug);
        if (entry.State == EntityState.Detached)
        {
            context.MY_GROUPS.Attach(ug);
        }

        context.MY_GROUPS.Remove(ug);
        context.SaveChanges();
    }
}

If this method changed from passing a single instance of MY_GROUPS to a List how would I handle the delete?

Would there be a more efficient way then just doing a foreach and setting the state one at a time?

UPDATE: I am already using a similar method as above utilizing the RemoveRange method. However I am getting an error:

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

I'm looking for the best way to attach a list of objects to the context so that I can delete them.

user_9535881 · Answer

I found this it worked for me. I did it in a loop before calling save changes. I wanted it to create just the delete sql command and it did.

http://www.entityframeworktutorial.net/entityframework6/delete-disconnected-entity-in-entity-framework.aspx

// disconnected entity to be deleted
var student = new Student(){ StudentId = 1 };

using (var context = new SchoolDBEntities())
{
    context.Entry(student).State = System.Data.Entity.EntityState.Deleted;    

    context.SaveChanges();
}

How to delete a list of objects in EF6 when the object is detached from the context

6 Answers