title: Get the latest inserted PK after submitting a linq insert stored procedure
body: <p>I have a stored procedure that updates a table using linq, eg: (this is just example code by way)</p>
  
  <pre><code>using (DataContext db = new DataContext())
  {
      d.sp_Insert_Client( textboxName.Text, textBoxSurname.Text);
  }
  </code></pre>
  
  <p>What I would like to know is how to retrieve (if possible) newly generated primary key of the above inserted row, as I need this primary key as a foreign key to complete another insert. </p>