Entity Framework Cascade Delete

Question

I have Table A and Table B on SQL Server.

Table B has an foreign key to Table A.

I want to cascade delete Table B itens when I delete a Table A item.

How to set this on SQL Server and on Entity Data Model?

score 1 · Accepted Answer · answered Aug 20 '12 at 13:33

1

On the SQL server, set the Delete Rule in INSERT and UPDATE specification on the relationship property to Cascade.

answered Aug 20 '12 at 13:33

podiluska

Where? On the foreign key properties of this relationship? I had this doubt because it is not intuitive. It doesn't say wich end of the relationship it reffers. Thanks, man. – programad Aug 20 '12 at 13:35
1

Yes. The cascade delete will apply when the "master" is deleted, deleting all the "children" – podiluska Aug 20 '12 at 13:38

score 0 · Answer 2 · answered Aug 20 '12 at 13:34

0

Set CASCADE on the relationship in the Entity Model Designer...

answered Aug 20 '12 at 13:34

Martin Milan

2 Answers2