| Name | Description |
| BeginTransaction |
Begin a new transaction
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| BuildDatabaseSpecificConnectionString | Overridden.
Build a connection string based on the passed in database
|
| ChangeDatabase | Overridden.
Change database
|
| ClearLog | Overloaded.
Clear the file log
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| CloseConnection |
Close the database connection
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| CommitTransaction |
Commit the current transaction
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| ConnectionValid |
Opens and closes the connection to ensure it is valid.
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| CountRecordsInTable | Overridden.
Get the number of records in a table
|
| CreateDatabase | Overridden.
Create new database
|
| DatabaseExists | Overridden.
Check database existance
|
| DisableLogging |
Disable all logging
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| Dispose |
Close the connection on Dispose
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| DropTable |
Drop (remove) a table from the database
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| EnableLogging | Overloaded.
Log to the console
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| ExecuteNonQuery | Overloaded.
Execute the passed query and return the number of affected records
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| ExecuteNonQuerySproc | Overloaded.
Execute the passed stored procedure and return the number of affected records. Output parameters will be set on return.
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) |
| ExecuteScalar | Overloaded.
Execute the passed query and return the first column of the first row
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| ExecuteScalarSproc | Overloaded.
Execute the passed stored procedure and return the first column of the first row
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) |
| FillDataTable | Overloaded.
Fill a data table with the passed sql and parameters
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| ForeignKeyExists |
Returns true if the Foreign Key Exists
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetAddColumnSql | Overridden.
Get the SQL for adding a column to an existing table
|
| GetAllForeignKeyConstraints | Overridden.
Get all constraints for the current database
|
| GetColumnDefinitionSql | Overridden.
Get portion of SQL used for the column definition for add column and create table sql
|
| GetCommentLine |
Get sql comment using the given comment text
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetCommentSeparatorLine |
Get comment separator line
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetCreateIndexSql |
Get the SQL to create the passed in index
|
| GetCreateSequenceSql | Overridden.
Currently not supported
|
| GetCreateTableSql |
Get the SQL for creating a table with the primary key
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetCreateTableSqlWithCompositeKey | Overridden.
Get the SQL for creating a table with composite keys
|
| GetCreateTableSqlWithPrimaryKey | Overridden.
Get the SQL for creating a table with a primary key
|
| GetCreateTablesSql |
Get the SQL to create the tables
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetCreateTriggerSql | Overridden.
Currently not supported
|
| GetDatabaseNameFromConnectionString | Overridden.
Get database name from connection string.
|
| GetDatabases | Overridden.
Get a list of databases for the database server
|
| GetDatabaseServerDate | Overridden.
Get the current database date
|
| GetDatabaseTables | Overridden.
Get a list of tables for the current database
|
| GetDatabaseTypeForDbType | Overridden.
Get the database field type for the passed standard DbType
|
| GetDataTable | Overloaded.
Get a datatable from the passed sql
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetDbType | Overridden.
Get a DbType associated with a string from a database
|
| GetDbTypeForClrType |
Get the DbType for provided ClrType
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetDropSequenceSql | Overridden.
Currently not supported
|
| GetDropTableSql | Overridden.
Get the sql to drop a table
|
| GetDropTriggerSql | Overridden.
Currently not supported
|
| GetFieldType | Overridden.
Get a .NET type associated with a string from a database
|
| GetIdentity |
Get the identity for the last insert in the current scope
|
| GetIdentitySql |
Get the SQL used to get the identity for the last inserted record
|
| GetIndexesForTable |
Gets the indexes for a table.
|
| GetMaxPrimaryKey |
Get the maximum value for the primary key
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetMaxPrimaryKeySql |
Get the SQL required to get the maximum value of the primary key
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetPagingSql |
Generate SQL that will get a page of records
|
| GetRecordsFromSproc |
Get records from stored procedure using passed parameters
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) |
| GetServerNameFromConnectionString | Overridden.
Get the server name from the connection string
|
| GetTopClause |
Get the top clause for a provider.
|
| GetTruncateSql | Overridden.
Get the sql to truncate a table.
|
| GetUpdateTablesSql |
Get the SQL to update the tables
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| IndexExists |
Detect if an index exists
|
| Load | Overloaded.
Get a list of records using the passed SQL
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| LoadFromSproc | Overloaded.
Get records by stored procedure with the passed parameters
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) |
| LoadOne | Overloaded.
Get a single record from a table with a parameterized where clause
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| LoadPage |
Get a page of records for a table
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| LoadTop | Overloaded.
Get a limited number of records for a table
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| MarkForeignKeys |
Mark foreign key columns by convention
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| MarkPrimaryKey |
Mark Primary Key in a table
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| MarkPrimaryKeys |
Mark primary key columns by convention
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| OpenConnection |
Open the database connection
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| RecordExists | Overloaded.
Returns true if the record exists
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| RollbackTransaction |
Perform a rollback of the current transaction
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| StoredProcedureExists | Overridden.
Returns true if the stored procedure exists
|
| TableExists | Overridden.
Returns true if the table exists
|
| TruncateTable |
Delete all the records from a table
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| Wrap |
Wrap a table name or field name in square brackets
(Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |