Using Filter

In NObject O/R Mapping persistence layer, you can update objects by filtering objects with FilterObject. Two FilterObjects are needed, one for conditional expression and one for updated property value, a sample is as follows:

Order filter = new Order(om);

filter.ShipVia = 1;

filter.EmployeeID = 7;

 

Order value = new Order(om);

value.ShipVia = 3;

 

om.UpdateMatch(filter, value);

The code above is equal to the following SQL:

UPDATE

  [Orders]

SET [Orders].[ShipVia] = 3

WHERE

  [Orders].[ShipVia] = 1 AND

  [Orders].[EmployeeID] = 7

Related Topics

Update Object