Constructing GroupBy Clause

Constructing GroupBy clause dynamically with ScalarList:

ScalarList selectList = new ScalarList();

selectList.Add(NW.Order.ShipVia);

selectList.Add(NW.Order.ShipRegion);

 

ScalarList groupByList = new ScalarList();

groupByList.Add(NW.Order.ShipRegion);

groupByList.Add(NW.Order.ShipVia);

 

SelectQuery query = OQL

  .Select(selectList)

  .From(NW.Order)

  .GroupBy(groupByList);

The SQL statements generated as follows (taking SQL Server as an example)

SELECT

  [Orders].[ShipVia] , [Orders].[ShipRegion]

FROM [Orders]

GROUP BY

  [Orders].[ShipRegion] , [Orders].[ShipVia]

 

Related Topics

Dynamic Construction of OQL