using System.Data.SqlClient; using System.Data.Common; string connectionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"; DbProviderFactory provider = SqlClientFactory.Instance; using (DbConnection connection = provider.CreateConnection()) { connection.ConnectionString = connectionString; connection.Open(); // Perform database operations here }
using System.Data.OracleClient; using System.Data.Common; string connectionString = "Data Source=OracleName;User Id=UserName;Password=Password"; DbProviderFactory provider = OracleClientFactory.Instance; using (DbConnection connection = provider.CreateConnection()) { connection.ConnectionString = connectionString; connection.Open(); // Perform database operations here }The DbProviderFactory class is a part of the System.Data.Common namespace and is included in the .NET Framework.