Update with inner query

[rsr-maersk]

Hi
Any idea how to:

UPDATE Foo SET [Bar] = (SELECT FORMAT(id, '00000')) where id IN (@ids)

I.e. a query assigned to the Set of a column.. I have tried all sorts. But need the a func parameter i imagine

[ahmad-moussawi]

Yes you can use here the UnsafeLiteral to pass raw string

var query = new Query("Foo")
    .WhereIn("id", new [] {1, 2})
    .AsUpdate(new {
        Bar = new UnsafeLiteral("SELECT FORMAT(id, '0000')", replaceQuotes: false)
    });

Check this example on playground