The Database..::..TransactionsClass type exposes the following members.

Methods

  Name Description
Public method Begin()()()()
Notifies that a transaction has begun and that all modifications to the database are only committed after a call to Commit. Alternatively, if Rollback is called then all changes are aborted. To execute other statements for the transaction call the Execute and ExecuteNonQuery functions. Because all changes to the database must be executed on the same connection DatabaseObjects maintains an open connection until the Commit or Rollback functions are called. When transactions are not being used connections are opened and closed for each SQL statement executed i.e. (INSERT/UPDATE/SELECT...).
Public method Begin(IsolationLevel)
Notifies that a transaction has begun and that all modifications to the database are only committed after a call to Commit. Alternatively, if Rollback is called then all changes are aborted. To execute other statements for the transaction call the Execute and ExecuteNonQuery functions. Because all changes to the database must be executed on the same connection DatabaseObjects maintains an open connection until the Commit or Rollback functions are called. When transactions are not being used connections are opened and closed for each SQL statement executed i.e. (INSERT/UPDATE/SELECT...).
Public method Commit
Commits all statements that have been executed after the Begin() call. The database connection is closed after the transaction has been committed.
Public method Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public method Execute(ISQLStatement)
Allows an SQL statement to be executed on the current transaction connection. If a transaction is not in progress an exception will occur.
Public method Execute(array<ISQLStatement>[]()[][])
Allows the SQL statements to be executed on the current transaction connection. If a transaction is not in progress an exception will occur.
Public method ExecuteNonQuery(ISQLStatement)
Allows an SQL statement to be executed on the current transaction connection. If a transaction is not in progress an exception will occur.
Public method ExecuteNonQuery(array<ISQLStatement>[]()[][])
Allows the SQL statements to be executed on the current transaction connection. If a transaction is not in progress an exception will occur.
Protected method Finalize
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
Public method GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected method MemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public method Rollback
Rollsback all statements that have been executed after the Begin() call. The database connection is closed after the transaction has been rolled back. Subsequent calls are ignored.
Public method ToString
Returns a String that represents the current Object.
(Inherited from Object.)

Properties

  Name Description
Public property InProgress
Indicates whether a transaction is currently in progress, caused by a call to Begin. Once the final, outer Commit or Rollback has been called false is returned.

See Also