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