SelectQuery sel = OQL

  .Select(NW.Order.OrderID, NW.Order.OrderDate, NW.Order.RequiredDate)

  .From(NW.Order)

  .Where(NW.Order.EmployeeID == 5 & NW.Order.ShipVia == 1);

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

SELECT

  [Orders].[OrderID] , [Orders].[OrderDate] , [Orders].[RequiredDate]

FROM [Orders]

WHERE

  [Orders].[EmployeeID] = 5 AND

  [Orders].[ShipVia] = 1