Search code examples
c#mongodbmongodb-.net-driver

C# driver for MongoDb: how to use limit+count?


From MongoDb documentation: "On a query using skip() and limit(), count ignores these parameters by default. Use count(true) to have it consider the skip and limit values in the calculation." That's exactly what I need to count resulted elements for the specific query until it's over defined limit like 1000, but I do not see any way to do it in c# driver. Count of IMongoCollection and SetCount of IMongoCursor are both parameter-less. Any idea?


Solution

  • Use the Size method instead of Count, as that honors Skip and Limit.

    Console.WriteLine(collection.Find(query).SetSkip(0).SetLimit(1).Size());