public static QueryFactory CreateSqlKata(string sqlcontypestr, string sqlconstring)
{
IDbConnection connection = new MySqlConnectorAlias::MySql.Data.MySqlClient.MySqlConnection(sqlconstring);
Compiler compiler = SQLKataHelper.MySqlCompiler; //2
// var dttypesqlsugar = DbType.MySql;
switch (sqlcontypestr)
{
case "sqlite": //0
connection = new SqliteConnection(sqlconstring);
compiler = SQLKataHelper.SqliteCompiler;
break;
case "sqlserver": //1
connection = new SqlConnection(sqlconstring);
compiler = SQLKataHelper.SqlServerCompiler;
break;
case "postgre": //3
connection = new NpgsqlConnection(sqlconstring);
compiler = SQLKataHelper.PostgresCompiler;
break;
}
return(new QueryFactory(connection, compiler));
}
public static PetaPoco.Database CreatePeta2(int dbtyp, string sqlconstring)
{
IDbConnection connection = null;
// var dttypesqlsugar = DbType.MySql;
switch (dbtyp)
{
case 1:
connection = new SqlConnection(sqlconstring);
break;
case 2:
connection = new SqliteConnection(sqlconstring);
break;
case 0:
connection = new MySqlConnectorAlias::MySql.Data.MySqlClient.MySqlConnection(sqlconstring);
break;
case 4:
connection = new NpgsqlConnection(sqlconstring);
break;
}
return(new PetaPoco.Database(connection));;
}
public static PetaPoco.NetCore.Database CreatePeta(string sqlcontypestr, string sqlconstring)
{
IDbConnection connection = new MySqlConnectorAlias::MySql.Data.MySqlClient.MySqlConnection(sqlconstring);
// var dttypesqlsugar = DbType.MySql;
switch (sqlcontypestr)
{
case "sqlite": //0
connection = new SqliteConnection(sqlconstring);
break;
case "sqlserver": //1
connection = new SqlConnection(sqlconstring);
break;
case "postgre": //3
connection = new NpgsqlConnection(sqlconstring);
break;
}
return(new PetaPoco.NetCore.Database(connection));
}
