Cosmos and SQL API, how can I project and remove fields
Hi all,
I am currently using
ReadItemAsync to read the content of an item. The are instances when I am not interested in all the fields, and I would dynamically filter out properties without have to create a new POCO.
In Mongo I can do this with a ProjectionDefinition, is there a way I can do this with the SQL API?1 Reply
Answer: https://blog.jeremylikness.com/blog/using-linq-to-query-dynamic-schemaless-cosmosdb-documents/
Developer for Life
Using LINQ to Query Dynamic Schema-less Cosmos DB Documents
A look at the latest Azure SDKs for .NET with a sample .NET Core app that uses the Cosmos DB SDK and LINQ to iterate over documents with a dynamic schema.