I'm going to back out of this conversation now because I'm not qualified to participate, but what is the best course to be notified of when this functionality is available? Thanks!
On Jul 13, 3:05 pm, Fabio Maulo <[email protected]> wrote: > What I mean with "impossible" is that we can't check the stack-trace to run > a query. > We need a new HQL syntax as, for instance > using (select a.Id from Animal a) as MyTemp from Animals s where a.Id in > MyTemp > > > > > > On Tue, Jul 13, 2010 at 4:42 PM, Vadim Chekan <[email protected]> wrote: > > I've never tried, but I can't see a reason why it would be impossible. > > > Vadim. > > > On Jul 13, 6:27 am, Mike <[email protected]> wrote: > > > I didn't realize this was possible. Are you saying that I can create > > > the temp table in my SP, and then reference it in an HQL or Criteria > > > query? > > > > On Jul 12, 9:54 pm, Vadim Chekan <[email protected]> wrote: > > > > > No, the funniest part is this: > > > > > > This worked great until .. hit the limit of allowed parameters in > > SQL Server 2005 > > > > > Mike, you need to predict how your code will work even before you > > > > wrote it. how much data is going to be retrieved, how many ID are > > > > going to be pushed back to sql, how much all this will take in RAM, > > > > etc. > > > > And always run sql profiler to see what your code is doing actually, > > > > otherwise it is source of horror stories :) > > > > > I would rather keep SP as SP. Leave data managing task to SQL Server, > > > > it is good with it. Without knowing details of your application, I > > > > would try to modify existing SP so that besides select, it creates a > > > > temporary table with selected IDs. Then you can select your related > > > > objects as "select * from MyRelatedObjects where ID in (select ID from > > > > #temp)". > > > > As a bonus you avoid ID roundtrip which will improve speed. > > > > > Vadim. > > > > > On Jul 12, 8:00 am, José F. Romaniello <[email protected]> wrote: > > > > > > This is the funny part: > > > > > > 2010/7/12 Mike <[email protected]> > > > > > > > At this point I do not have a business case to > > > > > > rewrite this Stored Procedure using NHibernate > > > > > > If this is not a "business case to rewrite the sp with NH", then you > > will > > > > > have to change your SP..... > > > > > forget about selecting with a list of ids. > > > -- > > 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. > > -- > Fabio Maulo -- 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.
