Cascade delete in asp.net

Hi,

 

You need to delete your reference table records first then pk table records, You can manage by Writing Store procedure if you are using ado. net, Please find link,

https://stackoverflow.com/questions/17191745/cascading-deletion-with-ado-net 

 

if you are using Entity Framework, Please use this link,

https://stackoverflow.com/questions/17487577/entity-framework-ef-code-first-cascade-delete-for-one-to-zero-or-one-relations