| 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 | Get the number of records in a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| CreateDatabase | Overloaded. 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 to add a column to a table |
| GetAllForeignKeyConstraints | Overridden. Get all the foreign key constraints in the 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 an index |
| GetCreateSequenceSql | Overridden. Get the sql to create sequence |
| 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. Get the sql to create trigger if it doesn't exist, alter trigger otherwise |
| GetDatabaseNameFromConnectionString | Overridden. Get database name from connection string. |
| GetDatabases | Overridden. Get a list of databases for the database server |
| GetDatabaseServerDate | Overridden. Get the date from the database server |
| 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 | Overridden. Get the DbType for provided ClrType |
| GetDropSequenceSql | Overridden. Get the sql to drop a sequence |
| GetDropTableSql | Overridden. Get the sql to drop a table |
| GetDropTriggerSql | Overridden. Get the sql to drop a trigger Delete trigger. Can only be performed by the owner of the trigger. Can not be performed when the trigger is currently running Dropping trigger will no longer increments table change count |
| GetFieldType | Overridden. Get a .NET type associated with a string from a database |
| GetIdentity | Get the identity for the last inserted record |
| GetIdentitySql | Get the SQL used to get the identity for the last inserted record |
| GetIndexesForTable | Get 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 | Returns true if the index exists for a table |
| 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 in the database |
| TruncateTable | Delete all the records from a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| Wrap | For Firebird table names and field names are not wrapped in square brackets or back ticks |
For a list of all members of this type, see FirebirdProvider members.
Public Methods
Protected Methods
Top
See Also