subsonicsubsonic2.2

SubSonic equivalent of an SQL update

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

Solution

  • You can execute this query using QueryCommand object of subsonic.

    You can find similar samples over here link and link