public static DbType GetDbType(string connectionStringName) { var providerName = ContextConnectionFactory.GetProviderName(connectionStringName).Lower(); var type = DbType.MSSql; switch (providerName) { case "mysql.data.mysqlclient": type = DbType.MySql; break; case "oracle.dataaccess.client": type = DbType.Oracle; break; case "postgresql ole db provider": type = DbType.PgSql; break; case "system.data.sqlclient": default: type = DbType.MSSql; break; } return(type); }
public static IDataProvider GetProvider(string connectionStringName) { var connectionString = ContextConnectionFactory.GetConnectionString(connectionStringName); var providerName = ContextConnectionFactory.GetProviderName(connectionStringName); var provider = ProviderFactory.GetProvider(connectionString, providerName); return(provider); }