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