Fetching and displaying more than 5000 list items

Question

I am aware of the list items threshold of 5000 items. But I need to display more than 5000 items on a SharePoint Hosted Addin and on a .net website.

How can I overcome this constraint? Also, I do wish to achieve this goal without compromising on the performance issues.

Any suggestion for the same would be highly appreciated.

Answer 1

The 5000 items threshold, restricts the number of items you can fetch using one query/view. You can read more than 5000 items by fetching the items in batches or provide pagination.

Here is another thread which has the CSOM code snippet to read list items in batches - Large list issue with CSOM