The Database..::..ConnectionController type exposes the following members.
Methods
Name | Description | |
---|---|---|
Equals | (Inherited from Object.) | |
Execute(ISQLStatement) |
Executes the SQL statement.
ConnectionController.Start must be called prior to and
ConnectionController.Finished afterwards or the statement be wrapped in a TransactionScope().
Otherwise the connection will not be correctly closed.
If wrapped in a TransactionScope call then Start is implicitly called if it has
not been called previously with the transaction scope.
|
|
Execute(array<ISQLStatement>[]()[][]) |
Executes the SQL statements.
ConnectionController.Start must be called prior to and
ConnectionController.Finished afterwards or the statement be wrapped in a TransactionScope().
Otherwise the connection will not be correctly closed.
If wrapped in a TransactionScope call then Start is implicitly called if it has
not been called previously with the transaction scope.
|
|
ExecuteInternal | ||
ExecuteNonQuery(ISQLStatement) |
Executes the SQL statement.
ConnectionController.Start must be called prior to and
ConnectionController.Finished afterwards or the statement be wrapped in a TransactionScope().
Otherwise the connection will not be correctly closed.
If wrapped in a TransactionScope call then Start is implicitly called if it has
not been called previously with the transaction scope.
|
|
ExecuteNonQuery(array<ISQLStatement>[]()[][]) |
Executes the SQL statements.
ConnectionController.Start must be called prior to and
ConnectionController.Finished afterwards or the statement be wrapped in a TransactionScope().
Otherwise the connection will not be correctly closed.
If wrapped in a TransactionScope call then Start is implicitly called if it has
not been called previously with the transaction scope.
|
|
ExecuteNonQueryInternal | ||
ExecuteNonQueryWithConnect(ISQLStatement) | Obsolete.
Executes an SQL statement on a new connection from the connection pool or
if in transaction mode the current connection.
ConnectionController.Start or ConnectionController.Finished do not have to be called.
|
|
ExecuteNonQueryWithConnect(array<ISQLStatement>[]()[][]) | Obsolete.
Executes the SQL statements on a new connection from the connection pool or
if in transaction mode the current connection.
ConnectionController.Start or ConnectionController.Finished do not have to be called.
|
|
ExecuteScalar |
Executes the SQL statement.
Returns Nothing/null if no record was selected, otherwise the first field from the
returned result.
ConnectionController.Start must be called prior to and
ConnectionController.Finished afterwards or the statement be wrapped in a TransactionScope().
Otherwise the connection will not be correctly closed.
If wrapped in a TransactionScope call then Start is implicitly called if it has
not been called previously with the transaction scope.
|
|
ExecuteScalarWithConnect |
Executes the SQL statement.
Returns Nothing/null if no record was selected, otherwise the first field from the
returned result.
ConnectionController.Start and
ConnectionController.Finished are automatically called.
|
|
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.) |
|
Finished | Obsolete.
Indicates that either Execute or ExecuteNonQuery have been called and are not
going to be called again.
If in transaction mode (Transactions.Begin has been called) then the
connection is left open until Transactions.Commit or Rollback is called.
If not in transaction mode then the connection is closed.
Always call Finished when finished using the connection whether in
transaction mode or not as the library will close the connection if necessary.
If called within a TransactionScope() then the database transaction will be committed
at the end of the TransactionScope().
|
|
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.) |
|
Start | Obsolete.
Indicates that either Execute or ExecuteNonQuery is going to be used
and that a connection needs to be opened if one is not already.
If in transaction mode (Transactions.Begin has been called) then the
current connection is left opened.
If not in transaction mode then a new connection is opened.
Always call Start before using Execute or ExecuteNonQuery whether in
transaction mode or not as the library will open the connection if necessary.
Once the connection is no longer required, call Database.Connection.Finished()
or Database.Transactions.Commit().
If called within a TransactionScope() then a database transaction is automatically started.
|
|
ToString | (Inherited from Object.) |
Events
Name | Description | |
---|---|---|
StatementExecuted |
Fired after an SQL statement has been executed.
Useful for trace logging of SQL statements executed.
|