The Database..::..TransactionsClass type exposes the following members.
Methods
Name | Description | |
---|---|---|
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...).
|
|
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...).
|
|
Commit |
Commits all statements that have been executed after the Begin() call.
The database connection is closed after the transaction has been committed.
|
|
Equals | (Inherited from Object.) | |
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.) |
|
GetHashCode |
Serves as a hash function for a particular type.
(Inherited from Object.) |
|
GetType |
Gets the Type of the current instance.
(Inherited from Object.) |
|
MemberwiseClone |
Creates a shallow copy of the current Object.
(Inherited from Object.) |
|
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.
|
|
ToString | (Inherited from Object.) |
Properties
Name | Description | |
---|---|---|
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.
|