title: EF: Delete record failed due to foreign key constraint
body: <p>I have <code>insteadOfDelete</code> triggers on my tables. Foreign Key Constraints are taken care of in <code>InsteadOfDelete</code> trigger. Since <code>InsteadOfDelete</code> trigger is present, <code>Cascade Delete</code> is removed.</p>
  
  <p>This means EF is unaware that I am taking care of Foreign Key Constraint outside of the Entity Frameworks' scope. Whenever, I try to delete a row from a table whose Primary Key is referenced by other tables I get an error saying one of the <code>foreign key property is non-nullable</code>.</p>
  
  <p>Is there a way to delete a record through <code>LINQ</code> without facing issues with Foreign Key Constraint?    </p>
  
  <p>Please note: <code>InsteadOfDelete</code> is used to solve multiple cascade path issue. More <a href="https://www.mssqltips.com/sqlservertip/2733/solving-the-sql-server-multiple-cascade-path-issue-with-a-trigger/" rel="nofollow">here</a>.</p>