The following tables list the members exposed by DbProvider.
Public Properties
| Name | Description | |
|---|---|---|
 | CanBatchQueries | Specifies whether the underlying database type for this provider can support multiple SQL statements per database round-trip |
| ConnectionString | Gets or sets the connection string this provider will use for database connections |
| MaxInListItems | Gets the maximum number of items the underlying database type supports in an IN() or NOT IN() SQL clause |
| ProviderName | A general provider type or key to classify this provider |
| RequiresDbNameParameter | Gets whether or not this provider requires the "dbname" argument for the CreateConnectionString Method |
| TypeMapper | This property is intended for future use and is not currently used. |
Public Methods
| Name | Description | |
|---|---|---|
  | ConstructConnectionString | Constructs a valid ADO.NET-compliant connection string from the supplied key/value pairs. |
| CreateCommand | |
| CreateConnectionString | Creates a basic connection string from the basic common required elements according the rules of the specific database type |
| CreateParameter | Creates a new IDbDataParameter of the specific underlying type for this database provider type (i.e. SqlHelper for MSSQL, etc) |
| FormatDateLiteral | Converts a DateTime value to a string according to the specific format of the underlying database type |
| GetAdapter | Overloaded. Gets a database type-specific DbDataAdapter instance for this provider type (i.e. SqlDataAdapter for MSSQL) without any options set yet. |
| GetAsStatement | Qualifies a column or table alias according to this provider's database type's rules regarding use of the AS keyword |
| GetBitwiseAndStatement | Formats a bitwise AND statement according to the language features of the underlying database type |
| GetConnection | Overloaded. Gets an IDbConnection object instance of the correct type for the underlying database (i.e. SqlConnection for MSSQL) that is prepared to connect to the specified database using the default connection string specified in the application configuration file. |
| GetDateStatement | Gets a SQL statement fragment for the database-specific syntax of retrieving the current date (i.e. SYSDATE on Oracle or GETDATE() on MSSQL). |
| GetDBDate | Executes a statement against the database to retrieve the current date/time on the database |
| GetDbVersion | Overloaded. Executes a statement against the database to retrieve the database software's version number |
| GetParameterNamePrefix | Gets the prefix used by the underlying database type for parameters in a parameterized query |
| ParseConnectionString | Parses a connection string into name-value pairs |
| PrepareParameter | Prepares a parameter for the specified type of query according to the rules of the underlying database type |
| PrepareSQLStatement | Prepares and formats a SQL statement according to the rules of the underlying database type |
| RemoveParameterNamePrefix | Removes, if necessary, the parameter name prefix on a given parameter name |
| SetDatabaseParameterTypeForClobText | |
| TestConnection | Overloaded. Executes a test to connect to the database using the default connection string |
| ValidateConnectionParams | Validates the supplied connection parameters against the rules of the underlying provider |
See Also