[nhusers] Re: Sql Server Executions Plans Still Not Working with prepare_sql = true?

2009-11-02 Thread Naz
Hi I'm pretty sure the setting doesn't change based on your driver you use we had to explicitly turn it on in our NHibernate config. Naz On Nov 1, 1:02 pm, zvolkov wrote: > Naz, I thought prepare_sql is set to true by default in NH 2.1 (when > using SqlClientDriver)... > &

[nhusers] Re: Sql Server Executions Plans Still Not Working with prepare_sql = true?

2009-10-31 Thread Naz
SQL driver. Naz On Oct 30, 11:43 pm, Fabio Maulo wrote: > at the end somebody with a way to confirm or deny an issue. > > @Carsten Thanks. > > @Andrei now you can add an episode to your story. Thanks > > Btw the point, IMO, is the same... I never saw the issue for MsSQL team,

[nhusers] Re: Sql Server Executions Plans Still Not Working with prepare_sql = true?

2009-10-30 Thread Naz
I know ;) "The ideal situation is alongside the fix you set parameter sizes in your mapping that match your table..." Naz On Oct 30, 12:58 pm, zvolkov wrote: > Naz, once the fix is in place, you can do it in the mappings by adding > type="AnsiString(LENGTH)" to ea

[nhusers] Re: Sql Server Executions Plans Still Not Working with prepare_sql = true?

2009-10-30 Thread Naz
tuation is alongside the fix you set parameter sizes in your mapping that match your table or if your to lazy to do that then at least if you know most of your nvarchar fields are say 255 length make that a default convention and only specify larger if required. Regards, Naz On Oct 29, 1:55 p

[nhusers] Re: Sql Server Executions Plans Still Not Working with prepare_sql = true?

2009-10-28 Thread Naz
roblem but actually only doing it for the current connection. In my opinion the default behaviour of the NHibernate SQLServer driver should be to SetParameterSizes() on every query it passes to the Database. Thanks Fabio for showing us how to implement our own driver. Regards, Naz On Oct 2

[nhusers] NHibernate SQL Generation Issue

2009-07-01 Thread naz
Hi, I get this error when executing the generated SQL - Ambiguous column name. It seems somehow the latest version of Castle I downloaded does not alias the order by clause. The old version use to work but this seems like a possible bug in the latest version of NHibernate. Anyone else experien