[eluser]OverZealous[/eluser]
[quote author="mcnux" date="1250175064"]Is there any reason why relationships aren't deleted before the object to be deleted is deleted? The benefit would be that foreign key constraints would no longer fail and, I think, it makes more sense to remove relationships before deleting, doesn't it?[/quote]
Well, I'd like to hear other's opinion on this, because somewhat I agree with you. (A lot of this code is not mine, so I don't always have the reasoning behind something.)
The only good reason I can see is that deleting the object first allows the Database to handle cascades, which should be significantly faster and safer (transactionally speaking).
If you have foreign constraints, you really should have deletion rules set up to cascade properly. This would prevent those errors. Since DMZ doesn't actually delete any related objects automatically, you still need to determine the correct order to delete objects in.
