ORMLite partial dynamic update

ServiceStack.OrmLite
1

Hi,

I want to update a single field of a number of rows. The field should be updated to a value +1/-1 to its prior value. A SQL-Equivalent would be:

update mytable 
  set sortIndex = sortIndex - 1
  where orderId >= 2 and orderId <= 5;

How would I do this with ORMLite (database agnostic) ?

cheers

2

Use the UpdateAdd APIs.