Group by¶

Use the GroupBy method of the IQuery object.

IAlias person = sql.Alias("person");

// Add group by to the query
IValList list = sql.ValList.Add(person["Name"], person["SurName"]);
IQuery query1 = sql.Query.GroupBy(list);

// Create group by
IQuery query2 = sql.Query
    .GroupBy(person["Name"], person["SurName"])

// Other options
IQuery query3 = sql.Query
    .GroupBy(x => x.Add(person["Name"], person["SurName"]));

With lambda expressions:

Person person = null;

// Add group by to the query
IValList list = sql.ValList.Add(() => person.Name, () => person.SurName);
IQuery query1 = sql.Query.GroupBy(list);

// Create group by
IQuery query2 = sql.Query
    .GroupBy(() => person.Name, () => person.SurName)

// Other options
IQuery query3 = sql.Query
    .GroupBy(x => x.Add(() => person.Name, () => person.SurName));