| AccessDatabaseAbstracter Class |
[Missing <summary> documentation for "T:Activsoft.Engine.Db.Access.AccessDatabaseAbstracter"]
Namespace: Activsoft.Engine.Db.Access
The AccessDatabaseAbstracter type exposes the following members.
| Name | Description | |
|---|---|---|
| AccessDatabaseAbstracter | Initializes a new instance of the AccessDatabaseAbstracter class |
| Name | Description | |
|---|---|---|
| BeginTransaction |
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.
(Inherited from AbstractDatabaseAbstracter.) | |
| BeginTransaction(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.
(Inherited from AbstractDatabaseAbstracter.) | |
| CloseCommand |
Closes a IDbCommand and if the abstracter is not in transaction mode, its underlying connection.
(Inherited from AbstractDatabaseAbstracter.) | |
| CloseReader |
Closes a IDataReader and if the abstracter is not in transaction mode, its underlying connection.
(Inherited from AbstractDatabaseAbstracter.) | |
| 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.
(Inherited from AbstractDatabaseAbstracter.) | |
| CreateAndAddParameter(IDbCommand, DbType, String, Object) |
Creates a SQL parameter and attaches it to the given IDbCommand.
(Inherited from AbstractDatabaseAbstracter.) | |
| CreateAndAddParameter(IDbCommand, DbType, String, ParameterDirection, Object) |
Creates a SQL parameter and attaches it to the given IDbCommand.
(Inherited from AbstractDatabaseAbstracter.) | |
| CreateAndAddParameter(IDbCommand, DbType, String, Int32, Object) |
Creates a SQL parameter and attaches it to the given IDbCommand.
(Inherited from AbstractDatabaseAbstracter.) | |
| CreateAndAddParameter(IDbCommand, DbType, String, Int32, ParameterDirection, Object) |
Creates a SQL parameter and attaches it to the given IDbCommand.
(Inherited from AbstractDatabaseAbstracter.) | |
| CreateSqlStatement | (Overrides AbstractDatabaseAbstracterCreateSqlStatement.) | |
| Dispose |
Cleans up all resources attached to the abstracter.
If the abstracter is in transaction mode, it rolls back the transaction.
(Inherited from AbstractDatabaseAbstracter.) | |
| Equals | (Inherited from Object.) | |
| 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).
(Inherited from AbstractDatabaseAbstracter.) | |
| 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).
(Inherited from AbstractDatabaseAbstracter.) | |
| 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.
(Inherited from AbstractDatabaseAbstracter.) | |
| 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.
(Inherited from AbstractDatabaseAbstracter.) | |
| 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.
(Inherited from AbstractDatabaseAbstracter.) | |
| ExecuteReader(IDbCommand) |
Executes a IDbCommand returning data.
(Inherited from AbstractDatabaseAbstracter.) | |
| ExecuteReader(String) |
Executes a SQL request returning data.
(Inherited from AbstractDatabaseAbstracter.) | |
| ExecuteReader(Config, SqlStatement) |
Executes a SqlStatement returning data.
Exclusion zones that end up being excluded are replaced by an empty string.
(Inherited from AbstractDatabaseAbstracter.) | |
| 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.
(Inherited from AbstractDatabaseAbstracter.) | |
| ExplainException | (Overrides AbstractDatabaseAbstracterExplainException(DbException, String, String).) | |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) | |
| GetCommand |
Creates a IDbCommand on the current connection.
(Inherited from AbstractDatabaseAbstracter.) | |
| 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.
(Inherited from AbstractDatabaseAbstracter.) | |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) | |
| GetType | Gets the type of the current instance. (Inherited from Object.) | |
| InnerGetCommand |
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
(Inherited from AbstractDatabaseAbstracter.) | |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
| OpenConnection | (Overrides AbstractDatabaseAbstracterOpenConnection.) | |
| 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.
(Inherited from AbstractDatabaseAbstracter.) | |
| 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.
(Inherited from AbstractDatabaseAbstracter.) | |
| 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.
(Inherited from AbstractDatabaseAbstracter.) | |
| 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.
(Inherited from AbstractDatabaseAbstracter.) | |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| Name | Description | |
|---|---|---|
| commandTimeOut |
The default command time out; this is the time .NET will wait for a SQL request to return data
(Inherited from AbstractDatabaseAbstracter.) | |
| connectionString |
The connection string to be used by this abstracter.
(Inherited from AbstractDatabaseAbstracter.) | |
| currentConnection |
If the abstracter is in transaction mode, it executes all its requests on this connection on which the transaction is open
(Inherited from AbstractDatabaseAbstracter.) | |
| currentTransaction |
If the abstracter is in transaction mode, the current transaction
(Inherited from AbstractDatabaseAbstracter.) | |
| inTransaction |
Whether the abstracter is in transaction mode
(Inherited from AbstractDatabaseAbstracter.) |
| Name | Description | |
|---|---|---|
| CommandTimeout |
Gets or sets the default command time out.
(Inherited from AbstractDatabaseAbstracter.) | |
| 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.
(Inherited from AbstractDatabaseAbstracter.) | |
| Type | (Overrides AbstractDatabaseAbstracterType.) |