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.
There’s no typed API for this.
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.