When a query involves related tables, the query can be simplified to an object expression.
Take the following Select statement as an example:
|
SelectQuery qryOrder =
OQL .Select(NW.Order) .From(NW.Order) .Where(NW.Order.CustomerID .In(OQL .Select(NW.Customer.CustomerID) .From(NW.Customer) .Where(NW.Customer.ContactTitle == "Owner"))); |
It can be simplified as:
|
SelectQuery qryOrder =
OQL .SelectFrom(NW.Order) .Where(NW.Order == (NW.Customer.ContactTitle == "Owner")); |
If you don’t want to add additional query conditions to the Where clause, it can be simplified further:
|
SelectQuery qryOrder =
OQL .SelectWhere(NW.Order == (NW.Customer.ContactTitle == "Owner")); |
Related Topics