无法枚举查询结果多次

Question

public List<DBUserCommentExt> GetAllUserCommentByID(int pagesize, int pageindex, int goodsID, CommentCategoryEnum categoryEnum, out int countNo)
        {
            var result=yepSkinProcudure.sp_UserCommnet_LoadUserCommnetInfo(goodsID, Convert.ToInt32(categoryEnum));
            countNo = result.Count();
            return result.Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();
        }

我用了一个拓展类为什么在分页的时候无法枚举查询结果多次

Answer 1

先Tolist 在对Tolist的对像 Count如&nbsp; var Temp = result.Tolist()countNo = Temp.Count();return Temp;

Answer 2

问题出在：countNo = result.Count();return result.Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();Count()和ToList()总共查询了2次，故报错，关于分页，你可以这样写：List<DBUserCommentExt> list = result.Tolist();return list.Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();