Using Filter

In NObject O/R Mapping persistence layer, you can also get objects by filtering objects with FilterObject.

l    Get all object-sets:

// get all orders

ObjectSet orders1 = om.GetObjectSet(NW.Order);

Console.WriteLine("Count [all] = {0}", orders1.Count);

foreach (Order order in orders1)

{

  //...

}

l    Filter according to a single field:

// filter by single field value

ObjectSet orders2 = om.GetObjectSet(NW.Order.EmployeeID, 4);

Console.WriteLine("Count [EmployeeId=4] = {0}", orders2.Count);

l    Filter according to multi-field:

// get by multi field value

Order orderFilter3 = new Order();

orderFilter3.CustomerID = "AROUT";

orderFilter3.ShipVia = 2;

 

ObjectSet orders3 = om.GetObjectSet(orderFilter3);

Console.WriteLine("Count [CustomerID='AROUT', ShipVia=2] = {0}",

  orders3.Count);

Related Topics

Return Existing Object and Object-set