Atomic Increment?

[adhip94]

Anyone has tried atomic increment? For example is it possible to write the below query using SQLKata querybuilder:

update mytable
set readcount = readcount + 1 
where myid = '123456'

[ahmad-moussawi]

@adhip94 why you have closed this?

[adhip94]

I didnt get any reply from anyone, and it was urgent since 1 week had passed, hence after discussing with a colleague I got a solution that worked.

var query = new Query("mytable")
  .Where("myid", "123456")
  .AsUpdate(new {
    readcount = new UnsafeLiteral("readcount  + 1"),
  });

Also FYI, when I run the above query in the SQLKata Playgrounds page, I get this.

[ahmad-moussawi]

Yes the UnsafeLiteral will help in this case, but this is an interesting feature to implement, I will reopen the issue.

Thanks for pointing out for the Playground issue, just fixed it.

[ahmad-moussawi]

This feature is now supported in 2.3.4 see #490 #489