SubSonic equivalent of an SQL update

subsonicsubsonic2.2

I'm wondering if the following SQL update query is possible using the equivalent SubSonic commands:

UPDATE MYTABLE SET MYFIELD = MYFIELD + 3 WHERE ANOTHERFIELD = ANOTHERVALUE

I couldn't find a suitable way to make a reference to the same field with the Setting object.

Any help on this will be greatly appreciated.

Regards,

Fernando

You can execute this query using QueryCommand object of subsonic.

You can find similar samples over here link and link