C# 事务之SqlTransaction

 private static void Execute(string connectionString)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                SqlTransaction transaction;
                using (SqlCommand cmd = connection.CreateCommand())
                {
                    //启动事务
                    transaction = connection.BeginTransaction();
                    cmd.Connection = connection;
                    cmd.Transaction = transaction;
                    try
                    {
                        cmd.CommandText = "sql语句！";
                        cmd.ExecuteNonQuery();

                        //完成提交
                        transaction.Commit();
                    }
                    catch(Exception ex)
                    {
                        //数据回滚
                        transaction.Rollback();
                        throw ex;
                    }
                }
            }

        }