Hello!

As far as I remember, SQL Server 2005 offers the usage of prepared SQL statements. As far as I remember, the SQL Server adapter for NHibernate does not offer the usage of prepared SQL statements. Is there works underway in scope of support for prepared SQL statements with SQL Server 2005 and hereby lowering the resources needed for creating execution plans over and over again?


Best regards,

Henrik Dahl

SQL Server has supported prepared statements for a while (at least SQL Server 2000, maybe earlier). However, they are turned off by default.

To turn it on, set hibernate.prepare_sql to true (on the configuration object, or the app.config.)

Judging by a statement by Mike Doerfler, they are turned off because there was not always a performance benefit (and sometimes a performance hit). If you find that to be different with SQL Server 2005, please let us all know.