Set dataset page size using CData ADO.NET Provider for SharePoint

Connection string

This CData ADO.NET Provider for SharePoint connection string can be used for connections to SharePoint.

Default is 1000 results per page. High page size results in fewer requests, but it may time out.

URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
Page Size=2000;