C# execute transact sql

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;
}

Source: stackoverflow.com

Similar codes

0 vote182 views1 answer
Sql commands in android
SQL
0 vote160 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
6 votes155 views4 answers
Sqlite drop table
SQL
3 votes179 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote168 views1 answer
Pl/sql loop example
SQL
2 votes182 views1 answer
Postgresql change value in column
SQL
7 votes169 views2 answers
Add column table pl sql
SQL
0 vote160 views1 answer
Sql replace id with name from another table
SQL
0 vote133 views1 answer
FindAllBy
SQL
0 vote203 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL