Adds a GROUP BY clause to the query. If you want to order the data by two columns you will need to call this method twice. If you call AddGroupBy, ANSI SQL requires an AddGroupBy for each AddResultColumn that is not an aggregate. Check your DBMS docs.
Adds an ORDER BY clause to the query using aggregates. Derived classes implement this, like SqlServerDynamicQuery and OracleDynamicQuery to account for differences in DBMS systems.
public abstract void AddGroupBy(AggregateParameter);
Adds a GROUP BY clause to the query using the FieldName of the SchemaItem. If you want to order the data by two columns you will need to call this method twice.
public virtual void AddGroupBy(SchemaItem);
Adds a GROUP BY clause to the query using the FieldName. If you want to order the data by two columns you will need to call this method twice.
public virtual void AddGroupBy(string);
DynamicQuery Class | NCI.EasyObjects Namespace