Click here to Skip to main content
15,894,907 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Scenario:

We are using SQL2005 driver when creating SQL connection to SqlServer 2008 R2 via NHibernate

C#
configuration = new Configuration().SetProperty(Environment.ReleaseConnections, "after_transaction")
                .SetProperty(Environment.Dialect, typeof(MsSql2005Dialect).AssemblyQualifiedName)
                .SetProperty(Environment.ConnectionDriver,
                             typeof(SqlClientDriver).AssemblyQualifiedName)
                .SetProperty(Environment.ProxyFactoryFactoryClass,
                             typeof(ProxyFactoryFactory).AssemblyQualifiedName)
                .SetProperty(Environment.ConnectionString, ConnectionProvider.GetConnectionString());


Question:

Will I get the same performance as when using MsSql2008Dialect, or to be more precise does database created in Sql2005 and Sql2008 server have same performances under SqlServer 2008 R2?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900