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?