| 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) |
For a list of all members of this type, see SqlServerProvider members.
Public Methods
Protected Methods
Top
See Also