I don't quite understand what your question is, other than you want to replace a stored proc with NH. sure it's possible, but there isn't nearly enough information here to say how to do that.
That fact that you have a single proc driving the entire dashboard doesn't seem plausible, but it could be one enormous proc. or it's just one proc to get things started and then additional queries to load the specifics of each widget. if your problem is you don't want NH to load all the results before processing. then you need to provide your own IList implmentation. here is post about the feature: http://ayende.com/blog/4548/nhibernate-streaming-large-result-sets -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/6xVrf9XlEq4J. 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.
