azure - 如何在 cosmosDB 中进行分页？

Question

我正在尝试使用 Cosmos 数据库进行分页，但跳过命令出现问题。

var resultDTO = this.client.CreateDocumentQuery<AuditDTO>(
             UriFactory.CreateDocumentCollectionUri(idDatabase, idCollection), queryOptions)

             .Skip(2*1)
             .Take(amount)
             .AsEnumerable()
             .ToList();

你知道如何实现吗？

Answer 1

目前支持分页，基于continuation token.

以下示例说明了一种根据所需页码、页面大小和继续标记查询文档的方法:

private static async Task<KeyValuePair<string, IEnumerable<CeleryTask>>> QueryCosmosDBPage(int pageSize, string continuationToken)
{
    DocumentClient documentClient = new DocumentClient(new Uri("https://{CosmosDB/SQL Account Name}.documents.azure.com:443/"), "{CosmosDB/SQL Account Key}");

    var feedOptions = new FeedOptions {
        MaxItemCount = pageSize,
        EnableCrossPartitionQuery = true,

        // IMPORTANT: Set the continuation token (NULL for the first ever request/page)
        RequestContinuation = continuationToken 
    };

    IQueryable<CeleryTask> filter = documentClient.CreateDocumentQuery<CeleryTask>("dbs/{Database Name}/colls/{Collection Name}", feedOptions);
    IDocumentQuery<CeleryTask> query = filter.AsDocumentQuery();

    FeedResponse<CeleryTask> feedRespose = await query.ExecuteNextAsync<CeleryTask>();

    List<CeleryTask> documents = new List<CeleryTask>();
    foreach (CeleryTask t in feedRespose)
    {
        documents.Add(t);
    }
    return new KeyValuePair<string, IEnumerable<CeleryTask>>(feedRespose.ResponseContinuation, documents);
}