title: Update database row after closing Link to SQL
body: <p>have code where I get rows from a database, extract information which is added to different tables, and update the original row with links to the new primary keys. My problem is that after getting the rows I need to process, I close the connection. I do this because I have quite a bit of processing before resubmitting, and I need to add rows to other tables and get their auto-generated primary keys. Unfortunately, while all of the other data is being added correctly, my original rows are not updating. </p>
  
  <p>First I get the rows I will be working with:</p>
  
  <pre><code>List&lt;Procedure&gt; result = new List&lt;Procedure&gt;();
  using (dbContext db = new dbContext(SqlAccess.ConnectionString))
  {
     var search =
        from Proc in db.GetTable&lt;Procedure&gt;()
        where Proc.ProcedureID == Guid.Empty
        select Proc;
     result = search.ToList&lt;Procedure&gt;();
  }
  </code></pre>
  
  <p>I then add rows to different tables, update the Procedure row, and try to check in:</p>
  
  <pre><code>using (dbContext db = new dbContext(SqlAccess.ConnectionString))
  {
     db.Findings.InsertAllOnSubmit(Findings);
     db.SubmitChanges();
  }
  </code></pre>
  
  <p>I'm sure I need to add something to my check-in code to say that I want to also check in my updates from the Procedure table, but I haven't been able to find what it is. Any assistance would be greatly appreciated.</p>