| Name | Description | |
|---|---|---|
 | BeginTransaction | Begin a new transaction |
| BuildDatabaseSpecificConnectionString | Build a connection string based on the passed in database |
| ChangeDatabase | Change database. |
| ClearLog | Overloaded. Clear the file log |
| CloseConnection | Close the database connection |
| CommitTransaction | Commit the current transaction |
| ConnectionValid | Opens and closes the connection to ensure it is valid. |
| CountRecordsInTable | Get the number of records in a table |
| CreateDatabase | Create new database |
| DatabaseExists | Check database existance |
| DisableLogging | Disable all logging |
| Dispose | Close the connection on Dispose |
| DropTable | Drop (remove) a table from the database |
| EnableLogging | Overloaded. Log to the console |
| ExecuteNonQuery | Overloaded. Execute the passed query and return the number of affected records |
| ExecuteScalar | Overloaded. Execute the passed query and return the first column of the first row |
| FillDataTable | Overloaded. Fill a data table with the passed sql and parameters |
| ForeignKeyExists | Returns true if the Foreign Key Exists |
| GetAddColumnSql | Get the SQL for adding a column to an existing table |
| GetAllForeignKeyConstraints | Get all constraints for the current database |
| GetColumnDefinitionSql | 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 |
| GetCommentSeparatorLine | Get comment separator line |
| GetCreateSequenceSql | Get the sql to create sequence |
| GetCreateTableSql | Get the SQL for creating a table with the primary key |
| GetCreateTableSqlWithCompositeKey | Get the SQL for creating a table with composite keys |
| GetCreateTableSqlWithPrimaryKey | Get the SQL for creating a table with a primary key |
| GetCreateTablesSql | Get the SQL to create the tables |
| GetCreateTriggerSql | Get the sql to create trigger |
| GetDatabaseNameFromConnectionString | Get database name from the connection string. |
| GetDatabases | Get a list of databases for the current database server |
| GetDatabaseServerDate | Get the date of the database server |
| GetDatabaseTables | Get a list of tables in the current database |
| GetDatabaseTypeForDbType | Get the database field type for the passed standard DbType |
| GetDataTable | Overloaded. Get a datatable from the passed sql |
| GetDbType | Get a DbType associated with a string from a database |
| GetDbTypeForClrType | Get the DbType for provided ClrType |
| GetDropSequenceSql | Get the sql to drop a sequence |
| GetDropTableSql | Get the sql to drop a table |
| GetDropTriggerSql | Get the sql to drop a trigger |
| GetFieldType | Get a .NET type associated with a string from a database |
| GetMaxPrimaryKey | Get the maximum value for the primary key |
| GetMaxPrimaryKeySql | Get the SQL required to get the maximum value of the primary key |
| GetServerNameFromConnectionString | Get the server name from the connection string |
| GetTruncateSql | Get the sql to truncate a table. |
| GetUpdateTablesSql | Get the SQL to update the tables |
| Load | Overloaded. Get a list of records using the passed SQL |
| LoadOne | Overloaded. Get a single record from a table with a parameterized where clause |
| LoadPage | Get a page of records for a table |
| LoadTop | Overloaded. Get a limited number of records for a table |
| MarkForeignKeys | Mark foreign key columns by convention |
| MarkPrimaryKey | Mark Primary Key in a table |
| MarkPrimaryKeys | Mark primary key columns by convention |
| OpenConnection | Open the database connection |
| RecordExists | Overloaded. Returns true if the record exists |
| RollbackTransaction | Perform a rollback of the current transaction |
| TableExists | Returns true if the passed table exists in the database |
| TruncateTable | Delete all the records from a table |
| Wrap | Wrap a table name or field name in square brackets |
For a list of all members of this type, see BaseDatabaseProvider members.
Public Methods
Protected Methods
| Name | Description | |
|---|---|---|
 | AddConstraints | Add constraints. |
| AddForeignKeyConstraints | Adds the foreign key constraints. |
| AddOtherFieldsThanPrimaryKey | Build the sql for fields other than the primary key |
| AddParameters | Adds parameters to the given command |
| BuildTopRecordsSql | Builds the top records SQL. |
| CreateCommand | Creates new command with the given command text |
| CreateConnection | Creates new connection |
| CreateDataAdapter | Creates data adapter using the given select command |
| GetEndBatchSql | Get SQL for batch end |
| GetPrimaryKeyColumnsForTable | Get the primary key columns for a table from the schema |
| GetRecords | Gets records using the given command |
| GetStartBatchSql | Get SQL for batch start |
| InterceptSql | Intercept the SQL and change it with the passed parameters |
| SetParameter | Sets parameter using the given parameter value |
See Also