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

Methods

  Name Description
Public method Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public method 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.
Public method 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.
Protected method ExecuteInternal
Public method 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.
Public method 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.
Protected method ExecuteNonQueryInternal
Public method 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.
Public method 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.
Public method 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.
Public method 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.
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 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().
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 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.
Public method ToString
Returns a String that represents the current Object.
(Inherited from Object.)

Events

  Name Description
Public event StatementExecuted
Fired after an SQL statement has been executed. Useful for trace logging of SQL statements executed.

See Also