DbProviderFactories Class (System.Data.Common)

Collapse All

Language Filter

This page is specific to

Microsoft Visual Studio 2010/.NET Framework 4

Other versions are also available for the following:

.NET Framework Class Library

DbProviderFactories Class

Represents a set of static methods for creating one or more instances of DbProviderFactory classes.

Inheritance Hierarchy

System..::.Object
System.Data.Common..::.DbProviderFactories

Namespace: System.Data.Common
Assembly: System.Data (in System.Data.dll)

Syntax

Visual Basic

Public NotInheritable Class DbProviderFactories

public static class DbProviderFactories

Visual C++

public ref class DbProviderFactories abstract sealed

[<AbstractClass>]
[<Sealed>]
type DbProviderFactories =  class end

The DbProviderFactories type exposes the following members.

Methods

	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.

Top

Version Information

.NET Framework

Supported in: 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Platforms

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.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Reference

System.Data.Common Namespace

Other Resources

DbProviderFactories (ADO.NET)

ADO.NET Managed Providers and DataSet Developer Center

Tags

: Add a tag

Community Content

Add new content

Annotations

How to use with example

Deepa Vashu Lakhani | Edit | Show History

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.