Linq To Entity 分页有关问题

Linq To Entity 分页问题

C# code

      public static List<User> PageUser(int pageIndex, int pageSize, out int count)        {            var query = (from User in entities.User                         orderby User.Id descending                         select User).Skip((pageIndex-1)*pageSize).Take(pageSize);                        count = entities.User.Count();            return query.ToList();        }

C# code

public List<TEntity> Page<TEntity>(string keys, int pageIndex, int pageSize, out int count) where TEntity : EntityObject{    using (var ctx = new XXXEntities())    {        var es = ctx.CreateObjectSet<TEntity>();        count = es.Count();        var query = es.OrderBy(keys).Skip((pageIndex - 1) * pageSize).Take(pageSize);         return query.ToList();    }}