Re: How do you get the @@identity for the record just inserted?

[Timothy Graupmann]

This command executes but it doesn't like the parameter "@@IDENTITY". so I'll just have to grab index 0 and hope that works.

myCommand = myConnection.CreateCommand();
myCommand.CommandText = "SELECT @@IDENTITY";
IDataReader reader = myCommand.ExecuteReader();
if (reader.Read())
{
newMeshNode.MeshNodeId = (UInt32)reader["@@IDENTIY"];
if(newMeshNode.MeshNodeId == 0)
throw new Exception("Invalid MeshNodeId was assigned.");
}