SQL SERVER ExecuteScalar

Aquí les muestro un ejemplo típico de insertar y recuperar el Id insertado

static public int AddProductCategory(string newName, string connString) {     Int32 newProdID = 0;     string sql =         "INSERT INTO Production.ProductCategory (Name) VALUES (@Name); "         + "SELECT CAST(scope_identity() AS int)";     using (SqlConnection conn = new SqlConnection(connString))     {         SqlCommand cmd = new SqlCommand(sql, conn);         cmd.Parameters.Add("@Name", SqlDbType.VarChar);         cmd.Parameters["@name"].Value = newName;         try         {             conn.Open();             newProdID = (Int32)cmd.ExecuteScalar();         }         catch (Exception ex)         {             Console.WriteLine(ex.Message);         }     }     return (int)newProdID; }

Fuente: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar.aspx

Saludos

Adalberto Montanía