Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Cascading Deletes Problem
Hi,
I have a table with a 'self-reference' relationship (Foreign Key: ParentId, Primary Key:Id)
I know that I cannot set cascading deletes on this because of potential recursion problems.
I tried a DELETE trigger instead which works IF the relationship is removed. But I need to keep the relationship in place for use with the EntityFramework. With the relationship in place the trigger fails because it is removing items in the wrong order (ie deleting an item before deleting the children)
So, instead, I tried using an INSTEAD OF DELETE trigger which deletes the children before the parent and this works OK.
BUT I need to define a cascading delete relationship between this table and another and I can't do that when the INSTEAD OF DELETE trigger is in place.
I'm stuck! Any suggestions,
TIA,
Viv
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement