Multi-database Environment

SelectQuery query = OQL

  .SelectFrom(NW.Order)

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

  .OrderBy(NW.Order.CustomerID);

 

// default : MS SQL Server, Oracle, etc...

OQL.DefaultSqlBuilder = CustomSqlBuilder.Default;

Console.WriteLine(query);

 

// Microsoft Access

Console.WriteLine();

Console.WriteLine(query.ToString(CustomSqlBuilder.Access));

 

// MySQL

OQL.DefaultSqlBuilder = CustomSqlBuilder.MySQL;

Console.WriteLine();

Console.WriteLine(query);

Related Topics

Using OQL.NET