C# MongoDB driver only returning 100 results

Question

I am writing a mailing label, and need to print a label for each document.

I have 829 documents on the Collection, but when I retrieve them, I only get 100 documents.

I have this LINQ code:

IMongoCollection Pessoa;
Pessoa = database.GetCollection<Pessoa>(collectionName);

return Pessoa.AsQueryable().ToList();

How to retrieve ALL the documents?

Answer 1

I have 829 documents on the Collection, but when I retrieve them, I only get 100 documents.

I could reproduce the issue on my side, using AsQueryable extension method on IMongoCollection collection.AsQueryable() to find documents in a collection, which always return 100 documents even though I changed Items per page setting to Unlimited on Azure portal.

Setting:

Test code:

Count documents in query explorer:

To query all the documents in a collection, as you mentioned in comment, you could try to call Find method with an empty filter.

Answer 2

You're probably being limited by the default cursor BatchSize. You can modify this behaviour passing an AggregateOptions object to the AsQueryable extension and setting the BatchSize property to a large enough value.

public static IMongoQueryable<TDocument> AsQueryable<TDocument>(this IMongoCollection<TDocument> collection, AggregateOptions aggregateOptions = null)