Constructing a Select Clause

Constructing a Select clause dynamically with ScalarList:

ScalarList selectList = new ScalarList();

selectList.Add(NW.Order.ShipRegion);

selectList.Add(NW.Order.ShipVia);

 

SelectQuery query = OQL

  .Select(NW.Order.OrderDate)._(selectList)

  .From(NW.Order);

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

SELECT

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

FROM [Orders]

 

Related Topics

Dynamic Construction of OQL