The issue with using EF Core 6 and Cosmos DB to execute a query that includes a Count of a list within the entity inside the predicate is that it is not supported by Cosmos DB. Cosmos DB does not support server-side evaluations of expressions that involve collections or aggregates. This means that querying for entities based on the count of a list within them is not possible in Cosmos DB.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2023-05-27 13:19:39 +0000
Seen: 17 times
Last updated: May 27 '23
Why does querying by partition key using EF Core Cosmos DB not yield any results?
How can data be transferred from an Azure Storage Queue to Cosmos DB?
Is it possible to generate an Azure alert utilizing a Cosmos SQL query?
How can one transfer JSON data from CosmosDB to SQL using Synapse?
How can Orion be initialized with data that remains persistent?
What are the components that explain the state of ECMAScript execution context specification?
How can OMNET++ be used to simulate M/M/c/c?
How can I use oversampling to address a problem?
What is the method to determine the most precise categorization of data using Self Organizing Map?