Adds a table to the database if it does not alreay exist (SQL Server only). The table is created with a single IDENTITY column named ID. Additonal columns can be added with AddColumn(String, String, String).

Adds a column (if it does not already exist) to an existing SQL Server View (SQL Server Only)

Applys the batch of updates

Starts a database transaction

Closes the connection

Checks for the existence of a column in a table

Commits a database transaction

Derives the parameters for a stored procedure

Determines whether the specified Object is equal to the current Object.

Serves as a hash function for a particular type.

Returns the next or current Oracle sequence value

Gets the Type of the current instance.

Returns true if the Token parameter is a reserved word in the database

Returns a ListDictionary object representing the current record in a format suitable for serialising in JSON format

Creates a shallow copy of the current Object.

Opens the database connection

Returns then corresponding database parameter name for the supplied token

Parses the Sql statement for parameter names and returns a corresponding paramater collection

Qualifies a database object name to ensure that it can can be used in an SQL Statement.

Returns the string value for the current row in the Reader for the specified column name

Rolls back a database transaction

Sets the value of a parameter in a collection irrespective of case-sensitivity and whether the parameter is a simple value or IDbDataParameter object

Checks for the existence of a table in the database

Returns a String that represents the current Object.

Creates a vendor independent filter string for the Tables metadata collection to select on "user" tables.

implemented by provider

Prevents accidental execution of unqualified update/delete statements

If set to true then the connection is automatically closed if an error occurs

implemented by provider

The threshold in milliseconds above which details of commands executing for longer will be logged

The number of seconds before a command will timeout. 30 is the default. A value of 0 will prevent a timeout.

implemented by provider

Converts empty string to null values in update statements when set to true

The fully mapped path to the data source

The autoincrementing value assigned to the last inserted record (where applicable). Only set if ReturnAutoIncrementValue is set to true

The template used to qualify database object names containing spaces

implemented by provider

Determines if an attempt is made to fetch the value assigned by an autoincrementing column after an insert

The number of rows affected by the last ExecuteDelete(String) or ExecuteUpdate(String) method

Controls the display of the connection string when reporting an error condition

Controls the level of detail shown in any exceptions

implemented by provider

Controls the verbosity of the error message

The connection string (after any path mappings have been made)

The type of database connected to

Returns the major version number for the database

Indicates if database provider supports batch updates

The data provider used for the connection

Returns a list of reserved words for the database

Specifies the batch size for batch updates.

OnCommandConfigured event can be used to customise the configuration of the command just prior to it being executed.