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