title: Insert using DataContext and getting ID CSLA C#
body: <p>How can I retrieve the ID during an insert in C# using CSLA? The stored procedure does an insert into the database table and then has a <code>SELECT @Id</code> (which is set with the <code>SCOPE_IDENTITY()</code>) after the insert.</p>
  
  <p>This is the code to insert in C#:</p>
  
  <pre><code>using (var mgr = ContextManager&lt;PersonDataContext&gt;.GetManager("TestDB"))
  {
      var results = mgr.DataContext.up_StoredProcToInsert(
          "David",
          30,
      );
  }
  </code></pre>