public static int Delete <T, TJoin>(this IQueryRunner runner, FlatQuery <T, TJoin> query) where T : new()
{
var stmtList = new StatementList();
stmtList.Delete(query);
return(runner.ExecuteNonQuery(stmtList));
}
/// <summary>
/// UPDATE ... SET with row parameter
/// </summary>
public UpdateStatement(FlatQuery <T, TJoin> query, Expression <Action <TJoin, InsertBuilder <T> > > insertExpr)
{
Parent = query;
FromQuery = query.GetFromQuery <T>();
InsertExpression = insertExpr;
InsertFunction = insertExpr.Compile();
}
/// <summary>
/// UPDATE tbl JOIN tbl2 SET tbl.X = tbl2.Y ...
/// </summary>
public static int Update <T, TJoin>(this IQueryRunner runner, FlatQuery <T, TJoin> query, Expression <Action <TJoin, InsertBuilder <T> > > insertExpr) where T : new()
{
var stmtList = new StatementList();
stmtList.Update(query, insertExpr);
return(runner.ExecuteNonQuery(stmtList));
}
public GroupByQuery(FlatQuery <TFrom, T> parent, Expression <Func <T, TGroup> > groupExpr, Expression <Func <SelectorContext <T>, T, TProject> > projectExpr)
: base(parent)
{
ParentT = parent;
GroupExpression = groupExpr;
GroupFunction = groupExpr.Compile();
ProjectExpression = projectExpr;
ProjectFunction = projectExpr.Compile();
}
public DeleteStatement(FlatQuery <T, TJoin> parent)
{
Parent = parent;
FromQuery = parent.GetFromQuery <T>();
}
public void Delete <T, TJoin>(FlatQuery <T, TJoin> query) where T : new()
{
Queries.Add(new DeleteStatement <T, TJoin>(query));
}
/// <summary>
/// UPDATE tbl JOIN tbl2 SET tbl.X = tbl2.Y ...
/// </summary>
public void Update <T, TJoin>(FlatQuery <T, TJoin> query, Expression <Action <TJoin, InsertBuilder <T> > > insertExpr) where T : new()
{
Queries.Add(new UpdateStatement <T, TJoin>(query, insertExpr));
}
