| Name | Description | |
|---|---|---|
 | Connection | Get a reference to the database connection |
| ConnectionString | The connection string |
| ParameterPrefix | A character prefix for parameters such as @ for SQL Server |
The following tables list the members exposed by BaseDatabaseProvider.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | BeginTransaction | Begin a new transaction |
| CloseConnection | Close the database connection |
| CommitTransaction | Commit the current transaction |
| CreateDatabase | Create new database |
| DatabaseExists | Check database existance |
| Dispose | Close the connection on Dispose |
| ExecuteNonQuery | Overloaded. Execute the passed query and return the number of affected records |
| ExecuteScalar | Overloaded. Execute a query and return a single value |
| GetDatabaseServerDate | Get the date of the database server |
| GetTruncateSql | Get the sql to truncate a table. |
| Insert | Insert into a table |
| Load | Overloaded. Get a list of records using the passed SQL |
| 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 |
| Update | Updates the specified table name. |
Protected Methods
| Name | Description | |
|---|---|---|
 | AddParameters | Adds parameters to the given command |
| CreateCommand | Creates new command with the given sql |
| CreateConnection | Creates new connection |
| GetRecords | Gets records using the given command |
| SetParameter | Sets parameter using the given parameter value |
See Also
Reference
BaseDatabaseProvider Class
KellermanSoftware.NetCachingLibrary.DatabaseProviders Namespace
System.IDisposable