Skip() and Take() in Entity Framework

Question

I'm trying to load data as follows-

var outletList = (from c in db.OutletList
                  where c.EmployeeId == 1 
                  orderby c.VisitId descending select c).Take(10).Skip(skipQuantity);

int quantity = outletList.Count();    // it's zero

No data is being loaded. I'm new to Entity Framework, so, sorry if it is a foolish question.

Any help?

Answer 1

You should first Skip from the whole collection and after that Take.

var outletList = (from c in db.OutletList
                    where c.EmployeeId == 1 
                    orderby c.VisitId descending select c)
                    .Skip(skipQuantity).Take(10);