Returning @@identity As Int

 Hi All :-)

 

I'm trying to return the identity from a stored procedure but am getting the error - "specified cast is invalid" when calling my function.

Here is my stored procedure - ALTER Procedure TM_addTalentInvite @TalentID INT

AS

Insert INTO TM_TalentInvites

(

TalentID

)

Values

(

@TalentID

)

SELECT @@IDENTITY AS TalentInviteID

RETURN @@IDENTITY

 

And here is my function -  public static int addTalentInvite(int talentID)

{

// Initialize SPROCstring connectString = "Data Source=bla bla";

SqlConnection conn = new SqlConnection(connectString);SqlCommand cmd = new SqlCommand("TM_addTalentInvite", conn);

cmd.CommandType = CommandType.StoredProcedure;

// Update Parameterscmd.Parameters.AddWithValue("@TalentID", talentID);

conn.Open();int talentUnique = (int)cmd.ExecuteScalar();

conn.Close();return talentUnique;

}

Any help you can give me will be greatly appreciated thanks!