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