sql 查询
db.user.OrderByDescending(c => c.time).Skip(pageSize * (pageNumber - 1)).Take(pageSize).ToList();
take skip,书写顺序 似乎没影响。
mysql 查询
原生的分页查询语句
select * from table limit (pageindex-1)*pagecount,pagecount
似乎linq查询
只能
db.user.OrderByDescending(c => c.time).Skip(pageSize * (pageNumber - 1)).Take(pageSize).ToList();
//不能这样
db.user.OrderByDescending(c => c.time).Take(pageSize).Skip(pageSize * (pageNumber - 1)).ToList();