The issue
I am seeking clarification on how to query any child JSON object, regardless of index.
For example, in the documentation, we see:
.Where(e => e.Customer.GetProperty("Orders")[1].GetProperty("Price").GetInt32() = 8)
This is great to look for the 2nd order (index1) where the price is 8.
How can we write a query that looks for any order in the child collection of orders, where the prices is 8?
Further technical details
Npgsql version: 4.1.3
The issue
I am seeking clarification on how to query any child JSON object, regardless of index.
For example, in the documentation, we see:
.Where(e => e.Customer.GetProperty("Orders")[1].GetProperty("Price").GetInt32() = 8)This is great to look for the 2nd order (index1) where the price is 8.
How can we write a query that looks for any order in the child collection of orders, where the prices is 8?
Further technical details
Npgsql version: 4.1.3