Getting RETURN @@ IDENTITY value in C #

Question

Here is a very simple question. I have an SP that inserts a row into the table, and at the end the RETURN @@ IDENTITY statement appears. What I cannot find is a way to get this value in C #. I use the Enterprise library and use the method:

db.ExecuteNonQuery(cmd);

I tried cmd.Parameters [0] .Value to get a value, but which returns 0 all the time. Any ideas?

Answer 1

Dim c as new sqlcommand("...")

Dim d As New SqlParameter()
d.Direction = ParameterDirection.ReturnValue
c.parameters.add(d)

c.executeNonQuery

(@@IDENTITY) = d.value

It more or less looks like this ... either this, or simply return the value from the stored procedure as an output parameter.

Answer 2

, SCOPE_IDENTITY(), @@IDENTITY. .

Answer 3

. SCOPE_IDENTITY, INSERT. , @@IDENTITY . , TRIGGERS , INSERT.

. Books Online.

Answer 4

- ,

IDENT_CURRENT ( 'TableName')

http://www.velocityreviews.com/forums/t303448-return-identity-after-sql-insert.html

-Zubair http://zubairdotnet.blogspot.com

Answer 5

,

SqlCommand.ExecuteScalar()

, , SCOPE_IDENTITY() , @@IDENTITY