IngresTransaction Class
The IngresTransaction class represents a local, non-distributed database transaction. Each connection is associated with a transaction. This object allows manual commit or rollback control over the pending local transaction.
Created by the BeginTransaction method in the IngresConnection object. After Commit() or Rollback has been issued against the transaction, the IngresTransaction object can not be reused and a new IngresTransaction object must be obtained from the IngresConnection.BeginTransaction method if another transaction is desired.
IngresTransaction Class Declaration
The IngresTransaction class declaration is as follows:
C#: public sealed class IngresTransaction : System.Data.Common.DbTransaction
VB.NET: NotInheritable Public Class IngresTransaction
Inherits System.Data.Common.DbTransaction
IngresTransaction Class Example
The following is an implementation of the IngresTransaction class:
static void DemoTxn(string connstring)
{
IngresConnection conn = new IngresConnection(connstring);
ProviderTransaction txn;
conn.Open();
txn = conn.BeginTransaction();
IngresCommand cmd = new IngresCommand(
"update demo_personnel set name = 'Howard Lane' "+
" where number = 200", conn, txn);
int numberOfRecordsAffected = cmd.ExecuteNonQuery();
Console.WriteLine(numberOfRecordsAffected.ToString() +
" records updated.");
txn.Commit();
conn.Close();
}
IngresTransaction Class Properties
The IngresTransaction class has the following properties:
IngresTransaction Class Methods
The IngresTransaction class contains the following methods: