In previous versions ASP.NET relationship dialog box had option: "Cascade Delete Related Records"; it was radical solution for keeping data integrity. If this option selected and you delete a department from the database, all its related categories would be automatically deleted by SQL Server. I used this option in my previous projects to let users delete ( after confirmation) record from parent table with all corresponding records in related tables. I don't see this option in ASP.NET 3.5.

Hi there,

You click the relation in the diagram and then open its Properties Grid. Then expand INSERT and UPDATE Specification and choose Cascade in the Delete drop-down.

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

I did not notice this option. It exists in SQL Server 2005 Relationship dialog box too. Now I see, that I can migrate my old projects without problem.

Thank you very much.