Cascading deletes

[wlandgraf (Wagner Landgraf)]

@Spelt Edward

If the application is running and I go with Sql management studio and delete a parent then the childs are still there.

That's not true. You won't be able to delete the parent, an error will be raised. You will have to delete all children first.