I'm using Entity Framework 4 and have a one-to-many relationship between a parent and child entity. I'm trying to delete a child using the parent repository by removing it from the parent's children collection:
public virtual void RemoveChild(Child child)
{
children.Remove(child);
}
When I try to save the changes I get the following error:
A relationship from the 'ParentChild' AssociationSet is in the 'Deleted' state. Given multiplicity constraints, a corresponding 'Child' must also in the 'Deleted' state.
Surely I don't have to delete the child entity explicitly using a child repository!
What I've come across to solve this problem is the follwoing override on the DbContext:
public override int SaveChanges()
{
Set<Child>()
.Local
.Where(r => !Parent.Local.SelectMany(s => s.Children).Contains(r))
.ToList()
.ForEach(r => Set<Child>().Remove(r));
return base.SaveChanges();
}
Take a look here: http://blog.oneunicorn.com/2012/06/02/deleting-orphans-with-entity-framework/