Single Database Environment

// set the value of OQL.DefaultSqlBuilder once in your program

OQL.DefaultSqlBuilder = CustomSqlBuilder.SqlServer;

 

SelectQuery selQuery = OQL

  .Select(NW.Order)

  .From(NW.Order)

  .Where(NW.Order.ShipVia == 2)

  .OrderBy(NW.Order.CustomerID);

 

Console.WriteLine(selQuery);

 

DeleteQuery delQuery = OQL

  .DeleteFrom(NW.Order)

  .Where(NW.Order.ShipVia == 2);

 

Console.WriteLine(delQuery);

Related Topics

Using OQL.NET