NObject O/R Mapping framework provides expert OQL.NET object query language to assist querying data-object and data object-set from database or object-set, a sample is as follows:
|
// from RDB Customer c = Customer.GetByCriteria(om, NW.Customer.CustomerID == "ALFKI" ); // from ObjectSet ObjectSet orders =
...; // get Sub ObjectSet ObjectSet subOrders
= orders.GetSubSet( NW.Order.ShipVia == 1&& NW.Order.EmployeeID == 7 ); // find a DataObject Order o = (Order)orders.Find( NW.Order.ShipVia == 1&& NW.Order.EmployeeID == 7 ); |
When OQL is used to query data-object in memory, it doesn't support multi-table's Join, Sub- query as well as Case, Like and Function.
Related Topics