I am having trouble petting such a beast as nHibernate: I am trying to eagerly load a collection for my class. I have tried using ICriteria, but it uses left outer join, which for one-to-many mappings results in duplicate rows, which can only be sorted by the code, and so paging doesn't work correctly.
So I moved to HQL, but it doesn't support SetMaxResults when doing "join fetch". Question here: http://stackoverflow.com/questions/2537592/why-doesnt-nhibernate-support-limit-when-doing-join-fetch So I moved to Future queries, but the IEnumerable that they return doesn't support Take(), Skip(), Count() or any of the extension methods. Frustrating to say the least. What can you advise on doing paging in such case? I want to do paging using Take() and Skip(), I have even written a small IQueryable implementation to support HQL, but that turned out to be unnecessary, given that Future already returns IEnumerable. -- 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.
