cosmos3_4

cosmos3_4.cs

public async Task<Note[]> AllSql()
{
    using (var client = new DocumentClient(new Uri(_endpoint), _key))
    {
        var link = UriFactory.CreateDocumentCollectionUri(_databaseId, CollectionId);

        var query = client.CreateDocumentQuery<Note>(link,
            "select * from notes",
            new FeedOptions()
            {
                EnableCrossPartitionQuery = true
            }
            )
            .AsDocumentQuery();

        var results = new List<Note>();
        while (query.HasMoreResults)
        {
            results.AddRange(await query.ExecuteNextAsync<Note>());
        }

        return results.OrderBy(x => x.Id).ToArray();
    }
}