CODEWITHSUNDEEP
sql-updatelinq2db
fedrok
fedrok

Reputation: 1

How to update a field by itself in linq2db

I mean, how can I translate the query

update myTable 
    set myField1 = myField1 + 1 
where myField2 = 'xyz'

Thank you

Upvotes: 0

Views: 222

Answers (1)

Svyatoslav Danyliv
Svyatoslav Danyliv

Reputation: 27356

There are several ways:

db.MyTable
   .Where(x => x.MyField2 == "xyz")
   .Set(x => x.MyField1, prev => prev.MyField1 + 1)
   .Update();

db.MyTable
   .Where(x => x.MyField2 == "xyz")
   .Update(prev => new MyTable { MyField1 = prev.MyField1 + 1 });

db.MyTable
   .Update(x => x.MyField2 == "xyz", 
      new MyTable { MyField1 = prev.MyField1 + 1 });

Upvotes: 1

Related Questions