/// <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)); }
/// <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> /// Add the given parameters to an <see cref="NpgsqlCommand"/> /// </summary> static void AddParams(NpgsqlCommand cmd, IEnumerable <SqlParam> sqlPars) { var pars = NpgsqlParamLogic.GetParams(sqlPars); foreach (var p in pars) { cmd.Parameters.Add(p); } }