Hi, I'm a newbee with nHibernate. I have a call that generate about 10 SQL queries in one call exec sp_executesql N' select .............; select .............; select .............; select .............; ',@p0='a',@p1='b',.....@p200='sdfsd'
I use the option 'ToFuture'. But, the major pb is that use more 200 parameters! And, SQL Server side, there is some times a "parameter sniffing" exception due to this huge call. When I remove the option 'ToFuture', I have more than 200 differents queries. Could someone help me? regards -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
