解决多行查询只能查询5000条的问题:
主要是加了一个do while循环,就可以一直查询下去
EntityCollection ec = null;
int pageNumber = 1;
do
{
QueryExpression query = new QueryExpression("Table");
query.ColumnSet = new ColumnSet("new_name");
query.PageInfo = new PagingInfo();
query.PageInfo.Count = 5000;//查询行数
query.PageInfo.PagingCookie = (pageNumber == 1) ? null : ec.PagingCookie;
query.PageInfo.PageNumber = pageNumber++;
query.Criteria.AddCondition("new_name", ConditionOperator.NotNull);
ec = serviceAdmin.RetrieveMultiple(query);
if (ec != null && ec.Entities.Count>0)
{
//逻辑
}
} while (ec != null && ec.MoreRecords);