DbProviderFactories Class
.NET Framework 4
Represents a set of static methods for creating one or more instances of DbProviderFactory classes.
Namespace:
System.Data.Common
Assembly: System.Data (in System.Data.dll)
The DbProviderFactories type exposes the following members.
| Name | Description | |
|---|---|---|
|
GetFactory(DataRow) | Returns an instance of a DbProviderFactory. |
|
|
GetFactory(DbConnection) | Returns an instance of a DbProviderFactory. |
|
|
GetFactory(String) | Returns an instance of a DbProviderFactory. |
|
|
GetFactoryClasses | Returns a DataTable that contains information about all installed providers that implement DbProviderFactory. |
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
How to use with example
Using DBProviderFactories we can actually create a connection without knowing what is the underlying database.
Example
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
The provider name can be placed in config file can have following
<add key="SQLDatabaseConnection" value="SqlServer">
<connectionStrings>
<add name="SqlServer" connectionString="data source=(local);Integrated Security=SSPI;Initial Catalog=NorthWind" providerName="System.Data.SqlClient"/>
</connectionStrings>
I can have a method
public IDbConnection ConnectionProvider(string providerName, string connectionString)
{
DbProviderFactory provider= DbProviderFactories.GetFactory(providerName);
IDbConnection connection=provider.CreateConnection();
connection.ConnectionString=connectionString;
return connection
}
this method can be called as follows
IDbConnection connection1=ConnectionProvider(ConfigurationManager.ConnectionStrings[ConfigurationManager.AppSettings[DATABASE_CONNECTION_CONFIG_KEY]].providerName, ConfigurationManager.ConnectionStrings[ConfigurationManager.AppSettings[DATABASE_CONNECTION_CONFIG_KEY]].ConnectionString)
DATABASE_CONNECTION_CONFIG_KEY can be "SQLDatabaseConnection" for sql. Similarly we can have different connection string and different key for Oracle or Access or any other database.
Example
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
The provider name can be placed in config file can have following
<add key="SQLDatabaseConnection" value="SqlServer">
<connectionStrings>
<add name="SqlServer" connectionString="data source=(local);Integrated Security=SSPI;Initial Catalog=NorthWind" providerName="System.Data.SqlClient"/>
</connectionStrings>
I can have a method
public IDbConnection ConnectionProvider(string providerName, string connectionString)
{
DbProviderFactory provider= DbProviderFactories.GetFactory(providerName);
IDbConnection connection=provider.CreateConnection();
connection.ConnectionString=connectionString;
return connection
}
this method can be called as follows
IDbConnection connection1=ConnectionProvider(ConfigurationManager.ConnectionStrings[ConfigurationManager.AppSettings[DATABASE_CONNECTION_CONFIG_KEY]].providerName, ConfigurationManager.ConnectionStrings[ConfigurationManager.AppSettings[DATABASE_CONNECTION_CONFIG_KEY]].ConnectionString)
DATABASE_CONNECTION_CONFIG_KEY can be "SQLDatabaseConnection" for sql. Similarly we can have different connection string and different key for Oracle or Access or any other database.
- 9/15/2010
- Deepa Vashu Lakhani
- 12/2/2010
- Deepa Vashu Lakhani
