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)); }