| Name | Description | |
|---|---|---|
 | Connection | Connection object |
| ConnectionString | Connection String |
| DatabaseName | Returns database name |
| IsConnectionOpen | Returns true if the connection is open |
| IsInTransaction | Returns true if we are in a transaction |
| ParameterPrefix | A character prefix for parameters such as @ for SQL Server |
| SupportComments | Returns true if the provider supports comments |
| Transaction | The current transaction |
The following tables list the members exposed by IDatabaseProvider.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | BeginTransaction | Begin a new transaction |
| 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 |
| Dispose | (Inherited from System.IDisposable) |
| DropTable | Drop (remove) a table from the database |
| 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 |
| GetCreateTableSql | Get the SQL for creating a table |
| GetCreateTableSqlWithCompositeKey | Get the SQL for creating a table with a composite key |
| GetCreateTableSqlWithPrimaryKey | Get the SQL for creating a table with a primary key |
| GetCreateTablesSql | Get the SQL to create the tables |
| 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 data table |
| GetDbTypeForClrType | Get DbType for provided ClrType |
| GetDropTableSql | Get the sql to drop a table |
| GetMaxPrimaryKey | Get the maximum value for a primary key |
| 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 one record where it is equal to the passed columnValue |
| LoadPage | Get a page of records for a table |
| LoadTop | Overloaded. Get a limited number of records for a table |
| MarkPrimaryKey | Mark the primary key of the passed table |
| 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 or back ticks |
See Also