How to create a complex query for Cosmos DB Table

From: https://docs.microsoft.com/en-us/azure/cosmos-db/tutorial-query-table

TableQuery<CustomerEntity> query = new TableQuery<CustomerEntity>()
    .Where(
        TableQuery.CombineFilters(
            TableQuery.GenerateFilterCondition(
"PartitionKey", QueryComparisons.Equal, "Smith"),
            TableOperators.And,
            TableQuery.GenerateFilterCondition(
"Email", QueryComparisons.Equal,"Ben@contoso.com")
    )); For different types use: GenerateFilterConditionForBinary
GenerateFilterConditionForBool
GenerateFilterConditionForDate
GenerateFilterConditionForDouble
GenerateFilterConditionForGuid
GenerateFilterConditionForInt

Comments