public IDbConnection CreateConnection() { var factory = new Oracle.ManagedDataAccess.Client.OracleClientFactory(); var dbConnection = factory.CreateConnection(); dbConnection.ConnectionString = connectionString; return(dbConnection); }
public static DbProviderFactory GetFactory(string providerName) { if (providerName == null) { throw new ArgumentNullException("providerName"); } DbProviderFactory dbFactory; switch (providerName) { case DbProviderNames.MySQL: case "MYSQL": case "MySQL": case "mysql": dbFactory = new MySqlClientFactory(); break; case DbProviderNames.Oracle_Managed_ODP: case "ORACLE": case "Oracle": case "oracle": dbFactory = new Oracle.ManagedDataAccess.Client.OracleClientFactory(); break; case DbProviderNames.SqlServer: case "SQLSERVER": case "SqlServer": case "sqlserver": dbFactory = SqlClientFactory.Instance; break; default: dbFactory = null; break; } return(dbFactory); }