Convert LINQ IQueryable to Page IQueryable Using LINQ to NHibernate

Question

I want to do something like this

public IQueryable GetPaged<TSource>(IQueryable<TSource> query, int startIndex, int pageSize) { return GetSession() .Linq<TSource>() .UseQuery(query) .Take(pageSize) .Skip(startIndex); } 

So, you can put any IQuerable statement and "it will be unloaded" or it will be unloaded.

I am using LINQ for NHibernate. I hope you understand this, swallow this bad English: o

edit: Maybe my approach is wrong, right?

Answer 1

This is copied from working code:

 public static class QueryableExtensions { public static IQueryable<T> Paged<T>(this IQueryable<T> source, int page, int pageSize) { return source .Skip((page - 1) * pageSize) .Take(pageSize); } } 

Answer 2

 return query.skip(startIndex).take(pageSize);