Hi, Thanks for your response.
We have stored precedure that will retrun multiple results set. For eg: Exec SP Retrun result set from SP : Object collection1, Object collection2, objection collection 3 etc.. In SQL we can use SQLdataReader to read data one by one from retrun result set collection from SP. We are looking similar way can we implement in nhibernate? I am seeing IMultiQuery looks same, but my conerns, can we execute SP using IMultiquery? Thanks, Ayyappa Kolli On Fri, Dec 2, 2011 at 7:52 AM, Jason Meckley <[email protected]>wrote: > 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. > -- 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.
