SubSonic equivalent SQL update

Question

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

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

I could not find a suitable way to link to the same field with the Setting object.

Any help on this would be greatly appreciated.

Hello,

Fernando

Answer 1

You can execute this query using the QueryCommand subsonic object.

Here you can find similar samples link and link

Answer 2

- "UpdateExpression" - , "" . - "SetExpression", , , .

Answer 3

, , SetExpression(), - , ... , ( ) - , ?

int count = new Update(MyTable.Schema).SetExpression("MyField").EqualTo("MyField + 20")
.Where(....)

, , , , ( ), , .