In NObject O/R Mapping persistence layer object-set, all the methods that get object-sets from database can be used to get sub-set from the existing object-set as follows:
l The method of filtering a single field:
|
ObjectSet orders = ...; ObjectSet subOrders = orders.GetSubSet(NW.Order.EmployeeID, 7); |
l The method of filtering multi-field:
|
ObjectSet orders = ...; Order filter = new Order(om); filter.ShipVia = 1; filter.EmployeeID = 7; ObjectSet subOrders = orders.GetSubSet(filter); |
l Using OQL:
|
ObjectSet orders = ...; ObjectSet subOrders = orders.GetSubSet(
NW.Order.ShipVia
== 1&& NW.Order.EmployeeID == 7 ); |
Note: the OQL here does not support multi-table's Join, sub-query, Case, Like and function.
Related Topics