| IDatabaseAbstracter Interface |
Defines a class providing a generic access to a SQL database.
Namespace: Activsoft.Engine.Db
Assembly: Activsoft.Engine (in Activsoft.Engine.dll) Version: 6.0.0.0
SyntaxThe IDatabaseAbstracter type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | BeginTransaction |
Puts the abstracter in transaction mode.
|
| BeginTransaction(IsolationLevel) |
Puts the abstracter in transaction mode with the given transaction isolation level.
|
| CloseCommand |
Closes a IDbCommand and if the abstracter is not in transaction mode, its underlying connection.
|
| CloseReader |
Closes a IDataReader and if the abstracter is not in transaction mode, its underlying connection.
|
| Commit |
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.
|
| CreateAndAddParameter(IDbCommand, DbType, String, Object) |
Creates a SQL parameter and attaches it to the given IDbCommand.
|
| CreateAndAddParameter(IDbCommand, DbType, String, ParameterDirection, Object) |
Creates a SQL parameter and attaches it to the given IDbCommand.
|
| CreateAndAddParameter(IDbCommand, DbType, String, Int32, Object) |
Creates a SQL parameter and attaches it to the given IDbCommand.
|
| CreateAndAddParameter(IDbCommand, DbType, String, Int32, ParameterDirection, Object) |
Creates a SQL parameter and attaches it to the given IDbCommand.
|
| CreateSqlStatement |
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.
|
| Dispose | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.) |
| ExecuteNonQuery(IDbCommand) |
Executes a IDbCommand not returning data (basically, anything but a SELECT, although postgresql, for example, can return data from INSERT / UPDATE / DELETE statements).
|
| ExecuteNonQuery(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).
|
| ExecuteNonQuery(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.
|
| ExecuteNonQuery(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.
|
| ExecuteNonQuery(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.
|
| ExecuteReader(IDbCommand) |
Executes a IDbCommand returning data.
|
| ExecuteReader(String) |
Executes a SQL request returning data.
|
| ExecuteReader(Config, SqlStatement) |
Executes a SqlStatement returning data.
Exclusion zones that end up being excluded are replaced by an empty string.
|
| ExecuteReader(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.
|
| ExplainException |
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.
|
| GetCommand |
Creates a IDbCommand on the current connection.
|
| GetCommand(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.
|
| Parse(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.
|
| Parse(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.
|
| Parse(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.
|
| Rollback |
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.
|
Properties| Name | Description | |
|---|---|---|
 | CommandTimeout |
Gets or sets the default command time out.
|
| ConnectionString |
Gets or sets the connection string used by this abstracter.
By default, the connection string is created by the configuration system, but you can force a custom connection string using this property.
|
| Type |
A string describing the underlying database.
|
See Also