Click or drag to resize
AbstractDatabaseAbstracter Methods

The AbstractDatabaseAbstracter type exposes the following members.

Methods
  NameDescription
Public methodBeginTransaction
Puts the abstracter in transaction mode using the Read Committed isolation level. From this point, and until a call to Commit or Rollback, all SQL requests will be executed on the same connection and transaction.
Public methodBeginTransaction(IsolationLevel)
Puts the abstracter in transaction mode using the given isolation level. From this point, and until a call to Commit or Rollback, all SQL requests will be executed on the same connection and transaction.
Public methodCloseCommand
Closes a IDbCommand and if the abstracter is not in transaction mode, its underlying connection.
Public methodCloseReader
Closes a IDataReader and if the abstracter is not in transaction mode, its underlying connection.
Public methodCommit
If the abstracter is in transaction mode, commits the transaction, closes the connection, and exits the transaction mode. If the abstracter is not in transaction mode, does nothing.
Public methodCreateAndAddParameter(IDbCommand, DbType, String, Object)
Creates a SQL parameter and attaches it to the given IDbCommand.
Public methodCreateAndAddParameter(IDbCommand, DbType, String, ParameterDirection, Object)
Creates a SQL parameter and attaches it to the given IDbCommand.
Public methodCreateAndAddParameter(IDbCommand, DbType, String, Int32, Object)
Creates a SQL parameter and attaches it to the given IDbCommand.
Public methodCreateAndAddParameter(IDbCommand, DbType, String, Int32, ParameterDirection, Object)
Creates a SQL parameter and attaches it to the given IDbCommand.
Public methodCreateSqlStatement
Creates a SqlStatement customized for the target database. To implement this method, you must derive from the SqlStatement class and return an instance of your class here.
Public methodDispose
Cleans up all resources attached to the abstracter. If the abstracter is in transaction mode, it rolls back the transaction.
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public methodExecuteNonQuery(IDbCommand)
Executes a IDbCommand not returning data (basically, anything but a SELECT, although postgresql, for example, can return data from INSERT / UPDATE / DELETE statements).
Public methodExecuteNonQuery(String)
Executes a SQL request not returning data (basically, anything but a SELECT, although postgresql, for example, can return data from INSERT / UPDATE / DELETE statements).
Public methodExecuteNonQuery(Config, SqlStatement)
Executes a SqlStatement not returning data (basically, anything but a SELECT, although postgresql, for example, can return data from INSERT / UPDATE / DELETE statements). Exclusion zones that end up being excluded are replaced by an empty string.
Public methodExecuteNonQuery(SqlStatement, String)
Executes a SqlStatement not returning data (basically, anything but a SELECT). Exclusion zones that end up being excluded are replaced by replaceEmptyZone. Since no Config object is passed to the method, the parameters values are not modified.
Public methodExecuteNonQuery(Config, SqlStatement, String)
Executes a SqlStatement not returning data (basically, anything but a SELECT, although postgresql, for example, can return data from INSERT / UPDATE / DELETE statements). Parameter values are read from the Config object. Exclusion zones that end up being excluded are replaced by replaceEmptyZone.
Public methodExecuteReader(IDbCommand)
Executes a IDbCommand returning data.
Public methodExecuteReader(String)
Executes a SQL request returning data.
Public methodExecuteReader(Config, SqlStatement)
Executes a SqlStatement returning data. Exclusion zones that end up being excluded are replaced by an empty string.
Public methodExecuteReader(Config, SqlStatement, String)
Executes a SqlStatement returning data. Parameter values are read from the Config object. Exclusion zones that end up being excluded are replaced by replaceEmptyZone.
Public methodExplainException
Database errors are not consistent across providers; error codes and error messages are always provider dependent. If you derive from this class, you must implement this method by casting the DbException to the provider specific exception and extracting the error code number and message.
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetCommand
Creates a IDbCommand on the current connection.
Public methodGetCommand(Boolean)
Creates a new IDbCommand and attaches it to a database connection. If the abstracter is in transaction mode, and openConnection is false, the connection used is the transaction connection. Else, a new connection is used.
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Protected methodInnerGetCommand
Creates a IDbCommand with the given SQL text, the default command timeout, and either using the current connection if the abstracter is in a transaction or a new one if it is not in a transaction
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodOpenConnection
Creates and opens a connection on the database.
Public methodParse(String, String, Int32)
Parses a list of SqlStatement from a semicolon separated string, a prefix and a starting number for the numeric parameters (see the format description). It uses the default formatters and transformers.
Public methodParse(String, String, Int32, DictionaryString, IFormatterFactory)
Parses a list of SqlStatement from a semicolon separated string, a prefix and a starting number for the numeric parameters (see the format description) and a custom list of formatters. It uses the default transformers.
Public methodParse(String, String, Int32, DictionaryString, IFormatterFactory, DictionaryString, KeyValuePairSqlType, IFormatterFactory)
Parses a list of SqlStatement from a semicolon separated string, a prefix and a starting number for the numeric parameters (see the format description) and a custom list of formatters. It uses the default transformers.
Public methodRollback
If the abstracter is in transaction mode, rolls back the transaction, closes the connection, and exits the transaction mode. If the abstracter is not in transaction mode, does nothing.
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
See Also