Click or drag to resize
SQLiteDatabaseAbstracter Methods

The SQLiteDatabaseAbstracter 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.
(Inherited from AbstractDatabaseAbstracter.)
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.
(Inherited from AbstractDatabaseAbstracter.)
Public methodCloseCommand
Closes a IDbCommand and if the abstracter is not in transaction mode, its underlying connection.
(Inherited from AbstractDatabaseAbstracter.)
Public methodCloseReader
Closes a IDataReader and if the abstracter is not in transaction mode, its underlying connection.
(Inherited from AbstractDatabaseAbstracter.)
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.
(Inherited from AbstractDatabaseAbstracter.)
Public methodCreateAndAddParameter(IDbCommand, DbType, String, Object)
Creates a SQL parameter and attaches it to the given IDbCommand.
(Inherited from AbstractDatabaseAbstracter.)
Public methodCreateAndAddParameter(IDbCommand, DbType, String, ParameterDirection, Object)
Creates a SQL parameter and attaches it to the given IDbCommand.
(Inherited from AbstractDatabaseAbstracter.)
Public methodCreateAndAddParameter(IDbCommand, DbType, String, Int32, Object)
Creates a SQL parameter and attaches it to the given IDbCommand.
(Inherited from AbstractDatabaseAbstracter.)
Public methodCreateAndAddParameter(IDbCommand, DbType, String, Int32, ParameterDirection, Object)
Creates a SQL parameter and attaches it to the given IDbCommand.
(Inherited from AbstractDatabaseAbstracter.)
Public methodCreateSqlStatement (Overrides AbstractDatabaseAbstracterCreateSqlStatement.)
Public methodDispose
Cleans up all resources attached to the abstracter. If the abstracter is in transaction mode, it rolls back the transaction.
(Inherited from AbstractDatabaseAbstracter.)
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).
(Inherited from AbstractDatabaseAbstracter.)
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).
(Inherited from AbstractDatabaseAbstracter.)
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.
(Inherited from AbstractDatabaseAbstracter.)
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.
(Inherited from AbstractDatabaseAbstracter.)
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.
(Inherited from AbstractDatabaseAbstracter.)
Public methodExecuteReader(IDbCommand)
Executes a IDbCommand returning data.
(Inherited from AbstractDatabaseAbstracter.)
Public methodExecuteReader(String)
Executes a SQL request returning data.
(Inherited from AbstractDatabaseAbstracter.)
Public methodExecuteReader(Config, SqlStatement)
Executes a SqlStatement returning data. Exclusion zones that end up being excluded are replaced by an empty string.
(Inherited from AbstractDatabaseAbstracter.)
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.
(Inherited from AbstractDatabaseAbstracter.)
Public methodExplainException (Overrides AbstractDatabaseAbstracterExplainException(DbException, String, String).)
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.
(Inherited from AbstractDatabaseAbstracter.)
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.
(Inherited from AbstractDatabaseAbstracter.)
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
(Inherited from AbstractDatabaseAbstracter.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodOpenConnection (Overrides AbstractDatabaseAbstracterOpenConnection.)
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.
(Inherited from AbstractDatabaseAbstracter.)
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.
(Inherited from AbstractDatabaseAbstracter.)
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.
(Inherited from AbstractDatabaseAbstracter.)
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.
(Inherited from AbstractDatabaseAbstracter.)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
See Also