private static Compiler GetCompiler <T>()
where T : IDbConnection, new()
{
Compiler result;
var name = typeof(T).Name;
switch (name)
{
case "SqliteConnection ":
result = new SqliteCompiler();
break;
case "FbConnection":
result = new FirebirdCompiler();
break;
case "MySqlConnection":
result = new MySqlCompiler();
break;
case "OracleConnection":
result = new OracleCompiler();
break;
case "NpgsqlConnection":
result = new PostgresCompiler();
break;
default:
result = new SqlServerCompiler();
break;
}
return(result);
}
public static Compiler GetCompiler(DatabaseType databaseType, string connectionString)
{
Compiler compiler = null;
if (databaseType == DatabaseType.MySql)
{
compiler = new MySqlCompiler();
}
else if (databaseType == DatabaseType.SqlServer)
{
compiler = new SqlServerCompiler
{
UseLegacyPagination = DatoryUtils.IsUseLegacyPagination(databaseType, connectionString)
};
}
else if (databaseType == DatabaseType.PostgreSql)
{
compiler = new PostgresCompiler();
}
else if (databaseType == DatabaseType.Oracle)
{
compiler = new OracleCompiler
{
UseLegacyPagination = DatoryUtils.IsUseLegacyPagination(databaseType, connectionString)
};
}
return(compiler);
}
public static SqlResult Compile(this Query query, string databaseType)
{
Compiler compiler = null;
if (DataBaseType == ConnectionType.MYSQL)
{
compiler = new MySqlCompiler();
}
else if (DataBaseType == ConnectionType.SQL)
{
compiler = new MySqlCompiler();
}
else if (DataBaseType == ConnectionType.ORACLE)
{
compiler = new OracleCompiler();
}
else if (DataBaseType == ConnectionType.SQLITE)
{
compiler = new SqliteCompiler();
}
else if (DataBaseType == ConnectionType.POSTRGRESQL)
{
compiler = new PostgresCompiler();
}
return(compiler.Compile(query));
}
public QueryBuilderTest()
{
mssql = new SqlServerCompiler();
mysql = new MySqlCompiler();
pgsql = new PostgresCompiler();
fbsql = new FirebirdCompiler();
oracle = new OracleCompiler();
}
public OracleLegacyLimitTests()
{
compiler = Compilers.Get <OracleCompiler>(EngineCodes.Oracle);
compiler.UseLegacyPagination = true;
}
public OracleDateConditionTests()
{
compiler = Compilers.Get <OracleCompiler>(EngineCodes.Oracle);
}
public OracleLimitTests()
{
compiler = Compilers.Get <OracleCompiler>(EngineCodes.Oracle);
}
