public static async Task <object> ExecuteScalarAsync(DbType type, System.Data.IDbTransaction transaction, string sql) { if (DebugMode) { Console.WriteLine(sql); } switch (type) { case DbType.MySql: return(await MySqlHelper.ExecuteScalarAsync(transaction, sql)); case DbType.SqlServer: return(await SqlServerHelper.ExecuteScalarAsync(transaction, sql)); case DbType.PostgreSql: return(await PgSqlHelper.ExecuteScalarAsync(transaction, sql)); case DbType.Sqlite: return(await SqliteHelper.ExecuteScalarAsync(transaction, sql)); default: throw new NotImplementedException(); } }
public static async Task <IEnumerable <T> > QueryAsync <T>(DbType type, string connectionString, string sql) { if (DebugMode) { Console.WriteLine(sql); } switch (type) { case DbType.MySql: return(await MySqlHelper.QueryAsync <T>(connectionString, sql)); case DbType.SqlServer: return(await SqlServerHelper.QueryAsync <T>(connectionString, sql)); case DbType.PostgreSql: return(await PgSqlHelper.QueryAsync <T>(connectionString, sql)); case DbType.Sqlite: return(await SqliteHelper.QueryAsync <T>(connectionString, sql)); default: throw new NotImplementedException(); } }