/// <summary> /// Execute the given statement and returns the number of affected rows /// </summary> public static async Task <int> ExecuteAsync <TDb>(this ISqlStatement statement, NpgsqlConnection conn) { var sql = statement.ToSql(); var pars = NpgsqlParamLogic.GetParams(sql.Params); return(await NpgsqlMapper.ExecuteAsync(conn, sql)); }
/// <summary> /// Execute the given statement and returns the number of affected rows /// </summary> public static int Execute <TDb>(this ISqlStatement statement, NpgsqlConnection conn) { var sql = statement.ToSql(); var pars = NpgsqlParamLogic.GetParams(sql.Params); return(NpgsqlMapper.Execute(conn, sql)); }
/// <summary> /// Execute the given query and returns the result as a read only list /// </summary> public static IReadOnlyList <T> ToList <T>(this ISqlQuery <T> select, NpgsqlConnection conn) { var sql = select.ToSql(); var pars = NpgsqlParamLogic.GetParams(sql.Params); return(NpgsqlMapper.Query <T>(conn, sql)); }