BigcommerceCommand1.Connection=BigcommerceConnection1;
using (TransactionScope transScope = new TransactionScope()) {
BigcommerceConnection1.Open();
BigcommerceCommand1.ExecuteNonQuery();
transScope.Complete();
}
BigcommerceConnection1.Close();
- or -
BigcommerceCommand1.Connection=BigcommerceConnection1;
BigcommerceConnection1.Open();
using (TransactionScope transScope = new TransactionScope()) {
BigcommerceConnection1.EnlistTransaction(Transaction.Current);
BigcommerceCommand1.ExecuteNonQuery();
transScope.Complete();
}
BigcommerceConnection1.Close();
- or -
CommittableTransaction cmtTx = new CommittableTransaction();
BigcommerceConnection1.Open();
BigcommerceConnection1.EnlistTransaction(cmtTx);
BigcommerceCommand1.ExecuteNonQuery();
BigcommerceConnection1.Close();