Retrieving the value of RETURN @@IDENTITY in C#

Question

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:

db.ExecuteNonQuery(cmd);

I've tried cmd.Parameters[0].Value to get the value but that returns 0 all the time. Any ideas?

Answer 1

BTW, in most circumstances, you should use SCOPE_IDENTITY() rather than @@IDENTITY. Ref.