| PostgresqlDatabaseAbstracter Methods |
The PostgresqlDatabaseAbstracter type exposes the following members.
| 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.) |