Increment a value, in a single update query

ServiceStack.OrmLite
1

Hi,
Is there a way to make an update query like this with ormlite, without using raw sql:

UPDATE User SET Balance = Balance + 100 WHERE User.Id = 1

I need to do this in one query to ensure that the balance does not change between reading and updating the user object.

2

There’s no typed API for this.

3

Ok, thanks. Maybe a better way to solve this is to have a layer between my database and my other services. As of right now several of my services/programs/threads can access the database directly and alter the same fields.