c# - .NET - c# - 需要跨分区查询，但禁用了 DocumentDB 数据访问问题

Question

我编写了以下代码来从 DocumentDB 中获取记录

private static void QueryDocuments1(DocumentClient client)
{

    IQueryable<SearchInput> queryable =
client.CreateDocumentQuery<SearchInput>(UriFactory.CreateDocumentCollectionUri(DocumentDBName, DocumentDBCollectionName))
        .Where(x => x.Receiver == "8907180");
    List<SearchInput> posts = queryable.ToList();
}

它在代码行 List<SearchInput> posts = queryable.ToList(); 上显示以下错误

{"Cross partition query is required but disabled. Please set x-ms-documentdb-query-enablecrosspartition to true, specify x-ms-documentdb-partitionkey, or revise your query to avoid this exception.\r\nActivityId: xxxxxx-xxxx-xxx-xxx-xxxxxxx"}

请帮助我...

Answer 1

您应该使用 CreateDocumentQuery 方法并将 FeedOptions 对象作为参数，此类具有 x-ms-documentdb-query-enablecrosspartition 的属性> 调用了 EnableCrossPartitionQuery。

请点击链接 https://msdn.microsoft.com/library/en-us/Dn850285.aspx对于休息 https://learn.microsoft.com/en-us/rest/api/documentdb/querying-documentdb-resources-using-the-rest-api

示例:

你应该有

 var option = new FeedOptions { EnableCrossPartitionQuery = true };
 IQueryable<SearchInput> queryable = client.CreateDocumentQuery<SearchInput>
 (UriFactory.CreateDocumentCollectionUri(DocumentDBName, 
 DocumentDBCollectionName), option ) .Where(x => x.Receiver == "8907180");