Db.UpdateAdd extension

ServiceStack.OrmLite Sqlite
1 
//Increase everyone's Score by 3 points
db.UpdateAdd(() => new Person { Score = 3 }); 
db.UpdateAdd(new Person { Score = 3 }, updateFields: x => x.Score); 

//Remove 5 points from Jackson Score
db.UpdateAdd(() => new Person { Score = -5 }, x => where: x.LastName == "Jackson");
db.UpdateAdd(new Person { Score = -5 }, x => x.Score, x => where: x.LastName == "Jackson");

//Graduate everyone and increase everyone's Score by 2 points 
var q = db.From<Person>().Update(x => new { x.Points, x.Graduated });
db.UpdateAdd(new Person { Points = 2, Graduated = true }, q);

//Add 10 points to Michael's score
var q = db.From<Person>()
    .Where(x => x.FirstName == "Michael")
    .Update(x => x.Points);
db.UpdateAdd(new Person { Points = 10 }, q);

I found above in the ormlite github, but I can’t use them

2.png1499×137 11.5 KB

I only have this 2 method, or I miss something?

2

UpdateAdd has got only this signature in class WriteExpressionCommandExtensions

3

yes , so the demo code on https://github.com/ServiceStack/ServiceStack.OrmLite/blame/master/README.md#L414 was wrong ?

4

Yep, I’ve just removed the non-existing API examples.