public async Task <T> ScalarResult <T>(BaseSelectQuery query, DbConnection con, DbTransaction tx, bool prepare = true)
{
using (var cmd = ToCommand(query, con, tx))
{
return(await ScalarResult <T>(cmd, prepare));
}
}
public PreparedCommand ToPreparedCommand(BaseSelectQuery query)
{
var r = new PreparingCommandResult();
Process(new SelectVisitor(), query, r);
return(r.Result);
}
public List <T> ScalarListResultSync <T>(BaseSelectQuery query, DbConnection con, DbTransaction tx, bool prepare = true)
{
using (var cmd = ToCommand(query, con, tx))
{
return(ScalarListResultSync <T>(cmd, prepare));
}
}
public List <T> ToListSync <T>(BaseSelectQuery query, DbConnection con, DbTransaction tx = null, bool prepare = true) where T : new()
{
using (var cmd = ToCommand(query, con, tx))
{
return(ToListSync <T>(cmd, prepare));
}
}
public async Task <List <T> > ToList <T>(BaseSelectQuery query, DbConnection con, DbTransaction tx = null, bool prepare = true) where T : new()
{
using (var cmd = ToCommand(query, con, tx))
{
return(await ToList <T>(cmd, prepare).ConfigureAwait(false));
}
}
public async Task <List <T> > ScalarListResult <T>(BaseSelectQuery query, DbConnection con, DbTransaction tx)
{
using (var cmd = ToCommand(query, con, tx))
{
return(await ScalarListResult <T>(cmd));
}
}
public T ScalarResultSync <T>(BaseSelectQuery query, DbConnection con, DbTransaction tx)
{
using (var cmd = ToCommand(query, con, tx))
{
return(ScalarResultSync <T>(cmd));
}
}
public void Visit(BaseSelectQuery query)
{
Result.Append("(");
new SelectVisitor {
Result = Result
}.Process(query);
Result.Append(")");
}
public DbCommand ToCommand(BaseSelectQuery query, DbConnection con, DbTransaction tx = null) => ToCommand <SelectVisitor, BaseSelectQuery>(query, con, tx);
public T FirstOrDefaultSync <T>(BaseSelectQuery query, DbConnection con, DbTransaction tx = null, bool prepare = true) where T : new()
{
using (var cmd = ToCommand(query, con, tx))
return(FirstOrDefaultSync <T>(cmd, prepare));
}
public string ToQueryText(BaseSelectQuery query) => ToQueryText <SelectVisitor, BaseSelectQuery>(query);
public async Task <T> FirstOrDefault <T>(BaseSelectQuery query, DbConnection con, DbTransaction tx = null) where T : new()
{
using (var cmd = ToCommand(query, con, tx))
return(await FirstOrDefault <T>(cmd).ConfigureAwait(false));
}
