How do you implement pagination in Cosmos DB?
Short answer: Use QueryDefinition and FeedIterator with MaxItemCount. var query = new QueryDefinition("SELECT * FROM c"); var iterator = container.GetItemQueryIterator<MyItem>(query, requestOptions: new QueryRequestOptions { MaxItemCount = 10 }); while (iterator.HasMoreResults) { foreach (var item in await iterator.ReadNextAsync()) { Console.WriteLine(item.Id); } }
Example code
Use QueryDefinition and FeedIterator with MaxItemCount. var query = new QueryDefinition("SELECT * FROM c");
var iterator = container.GetItemQueryIterator<MyItem>(query,
requestOptions: new QueryRequestOptions { MaxItemCount = 10 }); while (iterator.HasMoreResults) {
foreach (var item in await iterator.ReadNextAsync())
{ Console.WriteLine(item.Id); }
}
Real-world example (ShopNest)
ShopNest on Azure typically uses App Service + SQL Database + Blob Storage + Application Insights for monitoring.
Say this in the interview
- Define — one clear sentence (the short answer above).
- Example — relate it to a project like ShopNest or your real work.
- Trade-off — when you would not use it.
Share this Q&A
Share preview image: https://www.toolliyo.com/images/toolliyo-logo.png