This is the code I use:
EntityCollection retrievedRecords = new EntityCollection();
QueryExpression contactQuery = new QueryExpression
{
EntityName = "contact",
ColumnSet = new ColumnSet(true),
Criteria = new FilterExpression()
};
// you can add criteria
contactQuery.Criteria.AddCondition("firstname", ConditionOperator.Equal, "john");
int pageNumber = 1;
RetrieveMultipleRequest multiRequest;
RetrieveMultipleResponse multiResponse = new RetrieveMultipleResponse();
do
{
contactQuery.PageInfo.Count = 5000;
contactQuery.PageInfo.PagingCookie = (pageNumber == 1) ? null : multiResponse.EntityCollection.PagingCookie;
contactQuery.PageInfo.PageNumber = pageNumber++;
multiRequest = new RetrieveMultipleRequest();
multiRequest.Query = contactQuery;
multiResponse = (RetrieveMultipleResponse)service.Execute(multiRequest);
retrievedRecords.Entities.AddRange(multiResponse.EntityCollection.Entities);
}
while (multiResponse.EntityCollection.MoreRecords);
// now retrievedRecords contains all the records
My blog: www.crmanswers.net -
Rockstar 365 Profile
