Hi all

Is there a way to to what I would call sort of asynchronous requests with NHibernate ? Let me be more precise.

I have a request which return "lots of" datas. I would like to be able to start to display my datas in the UI as soon as the database begin to return me these datas, as some sql clients do.

I would imagine that the List() method return the result "instantaneously", then start to fill as fast as the database return datas, and that you can access to the first rows even if the request is not complete.
Note that I don't want to use nhibernate lazy loading, because I don't want to issue a new request for each line.

Is it possible ?

Thanks.

Have you looked at ISession/IQuery/ICriteria.Enumerable()? See, http://www.hibernate.org/hib_docs/nhibe ... a-querying , starting at the paragraph that begins "If you expect your query to return a very large number of objects..."

Maybe you could use pagination to fetch blocks of data in one thread and load them into the UI in an other thread.

you need a class to synchronise your threads with a queue and maybe a few flags (IsFinished, IsSuccess). Thread A would put load data block per block (with pagination) and put them in the queue and thread B would read the blocks from the queue and load them in the UI.

But do this only if you have a lot of data, and if you have too much data maybe you need to rethink your UI...

I don't think it is suited for me. The Enumerable() method first does a "light" request for getting the identifiers only. Then, when doing "foreach", you submit another request for each loop. So, if you fetch the entire collection, which is my case, you do n+1 select. It would slow a lot the UI. I would like to do only one request, as I know I need all the rows.



Thanks for the tips, but if I understand well, I would need to send one request for each block. It's not possible for my case.