I have two table one is Table A and another one is Table B both have fkMedicalInsurance column which is nullable

there is medical insurance table which is child table to above two able

As i deleting Related person , medical insurance doesn't get deleted , even though On Delete - cascade is set

How to do this using code first mapping ?

Hi try to recreate the ON delete cascade foriegn key on medical insurance table.

I'm not sure from your question exactly what the schema of your tables looks like, but if it is something like

Create Table FooMedicalInsurance(MedID int Primary Key)
Create Table FooTableA(TableAID int Primary Key, 
    fkMedicalInsurance int Foreign Key References FooMedicalInsurance On Delete Cascade)
Create Table FooTableB(TableAID int Primary Key, 
    fkMedicalInsurance int Foreign Key References FooMedicalInsurance On Delete Cascade)

then deleting from FooTableA or FooTableB will have no affect on FooMedicalInsurance.  But deleting row(s) from FooMedicalInsurance will delete the corresponding row(s) from FooTableA and FooTableB

Tom

• Proposed as answer by Eric__ZhangMicrosoft contingent staff, Moderator 49 minutes ago