DbProvider Class Members

The following tables list the members exposed by DbProvider.

Public Properties

  Name Description
Public Property CanBatchQueries Specifies whether the underlying database type for this provider can support multiple SQL statements per database round-trip  
Public Property ConnectionString Gets or sets the connection string this provider will use for database connections  
Public Property MaxInListItems Gets the maximum number of items the underlying database type supports in an IN() or NOT IN() SQL clause  
Public Property ProviderName A general provider type or key to classify this provider  
Public Property RequiresDbNameParameter Gets whether or not this provider requires the "dbname" argument for the CreateConnectionString Method  
Public Property TypeMapper This property is intended for future use and is not currently used.  

Public Methods

  Name Description
Public Methodstatic (Shared in Visual Basic) ConstructConnectionString Constructs a valid ADO.NET-compliant connection string from the supplied key/value pairs.  
Public Method CreateCommand  
Public Method CreateConnectionString Creates a basic connection string from the basic common required elements according the rules of the specific database type  
Public Method CreateParameter Creates a new IDbDataParameter of the specific underlying type for this database provider type (i.e. SqlHelper for MSSQL, etc)  
Public Method FormatDateLiteral Converts a DateTime value to a string according to the specific format of the underlying database type  
Public Method GetAdapter Overloaded. Gets a database type-specific DbDataAdapter instance for this provider type (i.e. SqlDataAdapter for MSSQL) without any options set yet.  
Public Method GetAsStatement Qualifies a column or table alias according to this provider's database type's rules regarding use of the AS keyword  
Public Method GetBitwiseAndStatement Formats a bitwise AND statement according to the language features of the underlying database type  
Public Method 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.  
Public Method 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).  
Public Method GetDBDate Executes a statement against the database to retrieve the current date/time on the database  
Public Method GetDbVersion Overloaded. Executes a statement against the database to retrieve the database software's version number  
Public Method GetParameterNamePrefix Gets the prefix used by the underlying database type for parameters in a parameterized query  
Public Methodstatic (Shared in Visual Basic) ParseConnectionString Parses a connection string into name-value pairs  
Public Method PrepareParameter Prepares a parameter for the specified type of query according to the rules of the underlying database type  
Public Method PrepareSQLStatement Prepares and formats a SQL statement according to the rules of the underlying database type  
Public Method RemoveParameterNamePrefix Removes, if necessary, the parameter name prefix on a given parameter name  
Public Method SetDatabaseParameterTypeForClobText  
Public Method TestConnection Overloaded. Executes a test to connect to the database using the default connection string  
Public Method ValidateConnectionParams Validates the supplied connection parameters against the rules of the underlying provider  

Reference

DbProvider Class
FChoice.Common.Data Namespace