Cosmos3_2

Cosmos3_2.cs

public int CountSql()
{
    using (var client = new DocumentClient(new Uri(_endpoint), _key))
    {
        var link = UriFactory.CreateDocumentCollectionUri(_databaseId, CollectionId);

        var count = client.CreateDocumentQuery<int>(
                            link,
                            "select value count(1) from notes",
                            new FeedOptions()
                            {
                                EnableCrossPartitionQuery = true
                            })
                        .AsEnumerable()
                        .First();
   
        return count;
    }
}