title: LINQ Getting The Next Row ID?
body: <p>Lets say I have a table with RowId, and Value:</p>
  
  <pre><code>1 valueA
  2 valueB
  3 valueC
  4 valueD
  </code></pre>
  
  <p>Then let's say I delete the 4th row:</p>
  
  <pre><code>1 valueA
  2 valueB
  3 valueC
  </code></pre>
  
  <p>So the next row ID will be 5.  Because the 4th row was deleted, I can't simply find the last row in the table and add 1 to get the next row ID.  How can I obtain the next row ID?</p>
  
  <p>Thanks!</p>