title: Retrieving the value of RETURN @@IDENTITY in C#
body: <p>Here's a very simple question. I have an SP that inserts a row into a table and at the end there's the statement RETURN @@IDENTITY. What I can't seem to find is a way to retrieve this value in C#. I'm using the Enterprise library and using the method:</p>
  
  <pre><code>db.ExecuteNonQuery(cmd);
  </code></pre>
  
  <p>I've tried <strong>cmd.Parameters[0].Value</strong> to get the value but that returns 0 all the time. Any ideas?</p>