Re:Relational is more than SQL
by ttfkam on Monday September 18, 2023 @08:00PM
(#37563918)
How would LINQ make jsonpath queries or unroll arrays on the database with unnest?
[ Parent
| on HN ]
LINQ in EntityFramework (EF) supports querying JSON columns as objects [1].
unnest support is potentially on the horizon for EF core for PG [2], but already supported for Couchbase [3].
[1] https://learn.microsoft.com/en-ca/ef/core/what-is-new/ef-cor...
[2] https://github.com/npgsql/efcore.pg/issues/1525
[3] https://github.com/couchbaselabs/Linq2Couchbase/blob/master/...