In
SharePoint, when you execute query on Large List, you will receive "The
attempted operation is prohibited because it exceeds the list view threshold
enforced by the administrator". To avoid this exception and read list
items by batch.
I have implemented CSOM solution and it’s published in Office Dev
PnP, below is the link
ListViewThresholdhttp://dev.office.com/blogs/PnP-Sep-2015-Release