EF Core & SQL Server, JSON Column Odata-like $select
intermediateadvanced
We're using EF 10. I want to be able to provide e.g.
$select=id,name,age
$select=id,name,age
to my API endpoint, which will perform this select in the DB
- It's a quite large json document, so ideally I would do this in the DB. Alternative is that I do this in memory - I would not prefer to do a lot of reflection / building expression trees myself. That's a maintenance nightmare - The system is plagued by bots and attackers night and day, so it must be secure