/// <summary>Agrega un campo con funcion agregada al listado de campos</summary> public Query AggAs(dbAgr aggregate, Query field, string fieldAlias) { instruction = dbItr.sel; Field fld = new Field(SanitizeSQL(fieldAlias), field); curUnion.lstAggFields.Add(new Aggregate(aggregate, fld, SanitizeSQL(fieldAlias))); return(this); }
public Particle(dbWTy wty, dbAgr agg, dbWin win, Expression expr, Dictionary <string, Constructor.dbOrd> orderBy, string[] partitionBy) { Operation = dbOpe.Over; Wty = wty; OrderBy = orderBy; PartitionBy = partitionBy; SetValue(expr); }
/// <summary>Agrega un campo con funcion agregada al listado de campos</summary> public Query AggAs(dbAgr aggregate, Expression expr, string fieldAlias) { instruction = dbItr.sel; Field fld = new Field(SanitizeSQL(fieldAlias), expr); fld.expression = expr; curUnion.lstAggFields.Add(new Aggregate(aggregate, fld, SanitizeSQL(fieldAlias))); return(this); }
public Aggregate(dbAgr aggregateFunct, Field insideField, string alias) { funct = aggregateFunct; field = insideField; fieldAlias = alias; }
private Expression(dbWTy wty, dbAgr agg, dbWin win, Expression expr, Dictionary <string, Constructor.dbOrd> orderBy, string[] partitionBy) { particles.Add(new Particle(wty, agg, win, expr, orderBy, partitionBy)); }
private Expression(dbAgr agg, Expression expr) { particles.Add(new Particle(agg, expr)); }
/// <summary>Agrega un campo con funcion agregada al listado de campos</summary> public Query Agg(dbAgr aggregate, Expression field) { return(AggAs(aggregate, field, "")); }
/// <summary>Agrega un campo con funcion agregada al listado de campos</summary> public Query Agg(dbAgr aggregate, Query field) { return(AggAs(aggregate, field, "")); }
/// <summary>Agrega un campo con funcion agregada al listado de campos</summary> public Query Agg(dbAgr aggregate, string field) { AggAs(aggregate, SanitizeSQL(field), ""); return(this); }
public Particle(dbAgr agg, Expression expr) { Operation = dbOpe.Agg; Agg = agg; SetValue(expr); }