That is exactly what NH do for HQL insert/update/delete... Perhaps would be useful the addition of a new HQL feature to do it with selects
-- Fabio Maulo El 12/07/2010, a las 23:54, Vadim Chekan <[email protected]> escribió: > 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]. > 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.
