I am in a situation where I need to retrieve a list of customers (>
200K) and various metrics (over 15) for each customer.
Each one of the metrics collection code (such as #site_logins,
#csrcalls etc) are already neatly written in criteria queries - but on
a individual customer basis.
I was able to project each of these existing criteria into a group by
Customer.Id.
So now I have potentially a stream of data each detached criteria
generates:
Customers, CustomerLogin { CustomerId, NumLogin } , CSRCall
{ CustomerId, NumCalls } and so on...
I want to enumerate each result for some calculation and do not want
to load everything to memory since it is a large data set
And doing the final (left) join in detached criteria I think is quite
complex...
I am at a point where I'm pondering the following:
1. Is it possible to stick everything in a multi-criteria and do the
final join there itself and get just the last record set?
2. A criteria transformer into a query would be helpful so that I can
iterate enumerate the result
3. Also does NH support MARS (multiple active record set) in SQL
server where I potentially can stream ALL the data...
Ajai
On Dec 9, 5:33 am, Diego Mijelshon <[email protected]> wrote:
> No, it's not possible. What do you need it for?
>
> Diego
>
> On Wed, Dec 9, 2009 at 00:26, ajaishankar <[email protected]> wrote:
> > Hi
>
> > Is it possible to do an Enumerate on a criteria than a List?
>
> > I see IQuery having an Enumerate method...
>
> > I'm trying to loop through the results similar to a data reader...
>
> > Thanks
>
> > Ajai
>
> > --
>
> > 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]<nhusers%[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.
