public IEnumerable<User> GetAll(int page = 1, int size = 10) { using(var ctx = new AlfasoftDBContext()){ return ctx.Set<User>() .OrderBy(u=>u.Name) .Skip((page-1) * (size)) .Take(size) .ToList(); } }