分布式事务管理 CommittableTransaction

对于分布式事务的处理与本地事务的处理有很大的区别，首先必须保证你所使用的数据库必须支持对分布式事务的支持，有些数据库只支持本地事务

 private void AddItem(int id, int money, Transaction trans)
        {
            SqlConnection conn = new SqlConnection(Str_DataBase);

            conn.Open();

            conn.EnlistTransaction(trans);

            

            SqlCommand command = conn.CreateCommand();
            command.CommandText = "INSERT INTO [t1] VALUES(@id,@money)";
            command.Parameters.AddWithValue("@id", id);
            command.Parameters.AddWithValue("@money", money);
            command.ExecuteNonQuery();

            conn.Close();
        }


        private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                CommittableTransaction trans = new CommittableTransaction();
             
                AddItem(3, 3, trans);
                AddItem(4, 4, trans);

                trans.Rollback();
                
            }
            catch (Exception e_con)
            {
                MessageBox.Show(e_con.Message);
            }
        }