Ozan Safi

It is quite easy to get the last inserted row id in TSQL.

Just create a stored procedure as below.

CREATE PROCEDURE InsertRow

( @parameter1 int, @parameter2 varchar(255), @NewId int OUTPUT )

AS

BEGIN

INSERT INTO table(parameter1, parameter2) VALUES(@parameter1, @parameter2)

SELECT @NewId=SCOPE_IDENTITY()

END

RETURN

… then; use it in a function like this:

public int InsertRowGetNewId(int intParam, string stringParam)

{

static string connectionString =      WebConfigurationManager.ConnectionStrings["connection"].ConnectionString;

using (SqlConnection conn = new SqlConnection(connectionString))

{

conn.Open();

SqlCommand cmd = new SqlCommand("InsertRow", conn);

cmd.CommandType = CommandType.StoredProcedure;

oParam =cmd.Parameters.AddWithValue("@parameter2", stringParam);

oParam = cmd.Parameters.AddWithValue("@NewId", 0);

//give a dummy value for the "@NewId" parameter

oParam.Direction = ParameterDirection.Output;

//set the direction of the parameter as output

cmd.ExecuteNonQuery();

return newId;

}

}