Hi I had a similiar problem. I'm using NH 3.2 and indeed it returns 0 rows.
before ===== var lista = session.QueryOver<Case> .Take(PageSize) .Skip(page * PageSize) .List<Case>(); NO RESULTS....0 RECORDS I looked at the NHprof profiler and analyzed the select statement that was made to oracle... and I solved the problem with this TWEAK. var lista = session.QueryOver<Case> .Take(page * PageSize + PageSize) .Skip(page * PageSize) .List<Case>(); IF YOU LOOK TO THE QUERY IN NHPROF OR TO THE LOG FILES THEN YOU WILL SEE WHAT I MEAN. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
