title: What is the best practice for inserting or updating multiple tables at once
body: <p>If I need to update or insert into multiple tables with one "action", example a call to save the information, where there are multiple tables that incorporate 'Information'.</p>
  
  <p>For arguments sake, lets say we have the following tables:</p>
  
  <p>Name
  Address
  Car
  Job</p>
  
  <p>and with each call to save information, each one of those tables is being inserted into.</p>
  
  <p>Which is better:</p>
  
  <ol>
  <li>Get the data that must be written to Name table. Call InsertOnSubmit and call SubmitChanges</li>
  <li>Get the data that must be written to Address table. Call InsertOnSubmit and call SubmitChanges</li>
  <li>Get the data that must be written to Car table. Call InsertOnSubmit and call SubmitChanges</li>
  <li>Get the data that must be written to Job table. Call InsertOnSubmit and call SubmitChanges</li>
  </ol>
  
  <p>or</p>
  
  <ol>
  <li>Get the data that must be written to Name table.</li>
  <li>Get the data that must be written to Address table.</li>
  <li>Get the data that must be written to Car table.</li>
  <li>Get the data that must be written to Job table.</li>
  <li>Call InsertOnSubmit, then call SubmitChanges.</li>
  </ol>
  
  <p>or</p>
  
  <ol>
  <li>Get the data that must be written to Name table. Call InsertOnSubmit</li>
  <li>Get the data that must be written to Address table. Call InsertOnSubmit</li>
  <li>Get the data that must be written to Car table. Call InsertOnSubmit</li>
  <li>Get the data that must be written to Job table. Call InsertOnSubmit</li>
  <li>Call SubmitChanges</li>
  </ol>
  
  <p>I have implemented the first option given and I am sure this is not the best way to go. I don't know if I have problems with my network connection or whatever, but sometimes some of the tables are written to while others are not and this makes me sure I am not doing it the best way possible.</p>
  
  <p>In some of the posts that are similar to this question, there are comments to do with Views and other options. I have no experience with this, so I need some guidance as to the best way to do this and which direction I should focus my attention on.</p>