How to implement JSONB queries and updates by using LINQ statements？

[maikebing]

I'm sorry, I can't stand LINQ and SQL appear simultaneously！
So, how to implement the following SQL statement using LINQ。

update   "DeviceTwins"  set "Reported" ="Reported" || '{    "status": "1"}'
where "ThingsID"='55afda72-fd93-4077-9012-189c23315ec3' and  "Properties" @> '{ "switch": "dzs9l.PV"  }'::jsonb

[roji]

You can't.

First, EF Core doesn't support set updates yet (see dotnet/efcore#795). Second, Npgsql doesn't support mapping LINQ to PostgreSQL-specific JSON syntax (such as @>), see #334.

To do the more complex stuff it's OK to occasionally drop down to SQL...

[pravin13khade]

@roji - Are we able to able to update the Jsonb column using Linq now? This issue seems old and looking for the latest information if any.

[roji]

No, not yet.