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