title: Linq-to-sql Delete a record with FK constraints
body: <p>Is it possible to SubmitChanges and ignore deletes that cause Foreign Key constraint errors? </p>
  
  <p>Say I have object A and B. B's Primary Key is a Foreign Key in A. Now I change a record A in which I replace B for another B and delete the original B. An error will occur when the deleted B is referenced in another record A (or other tables containing B as Foreign Key). Is it possible to ignore the error and let the changes be made in the database, without deleting the old B? </p>
  
  <pre><code>A rec_a = (from a in db.As where a.id == some_id).First();
  B rec_b_old = rec_a.B;
  rec_a.B = null;
  db.Bs.DeleteOnSubmit(rec_b_old);
  rec_a.B = some_other_b;
  db.SubmitChanges();
  </code></pre>