Toni, This is how the trunk version of NHibernate is behaving, even in the precense of prepare_sql false
On Thu, Apr 22, 2010 at 3:49 PM, Antonio Terreno <[email protected]>wrote: > Hi Guys, > sorry to post here rather than on the main nhibernate ML but I'm not > subscribed there (yet) and I'd need a prompt answer :-) > > The DBAs & a developer at the client where I am currently working are > pushing for changing the Nhibernate code (or write a custom driver) more or > less in the way described by the last comment on this ayende blog post: > http://ayende.com/Blog/archive/2009/05/02/nhibernate-the-database-query-cache-and-parameter-sizes.aspx > > So - personally I have made some local changes (which Fabio by the way is >> not interested in) to NHibernate (SQLClientDriver.cs) so SetParameterSizes() >> is ALWAYS called, but I'm leaving "prepare_sql" set to false. This gives me >> exactly the behaviour I want (verified with SQLProfiler and by looking at >> the statements in the executionplan cache in SQL server) >> > > > I would love to hear your impressions (for me it's just bad to change a > library in general common sense) and if you faced the same problem already, > afaik NHibernate is used successfully all around the world on big > applications and this DBA craziness is totally unjustified IMHO. > > Thanks for your help guys. > > toni > > -- > http://www.the-arm.com > > -- > You received this message because you are subscribed to the Google Groups > "NHibernate Contrib - Development Group" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhcdevs%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhcdevs?hl=en. > -- You received this message because you are subscribed to the Google Groups "NHibernate Contrib - Development Group" 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/nhcdevs?hl=en.
