SQL 2005 Support

zhan · **Posted:** Thu Jun 01, 2006 11:21 am

Dear all:

I am a newbie of NHibernate. I did some research and am still not sure about the answer of the following question.

Does the latest release version NHibernate 1.0.2 support MS SQL Server 2005? As I see that the NHibernate 1.2.0.Alpha1 support it. Is that a 'must' to use 1.2.0.Alpha1 if my backend database is SQL Server 2005?

Thanks a lot in advance.

Zhan

gert · **Joined:** Thu Jan 19, 2006 4:29 pm **Posts:** 348

SQL server 2000 dialect should also work with SQL 2005. Still, SQL 2005 dialect would propably work better ;)

Gert

zhan · **Posted:** Thu Jun 01, 2006 4:46 pm

Gert:

Thank you very much for the reply! It's amazing to know that SQL Server dialect 2000 can work for SQL Server 2005. Before I just wondered whether there will be version problem.

Have a great day!

kids_pro · **Joined:** Sun Oct 16, 2005 4:54 am **Posts:** 7

I saw there is a new driver for sqlserver 2005 in the 1.2.0alpha1 release but I haven't try it yet.

zhan · **Posted:** Fri Jun 02, 2006 9:25 am

kids_pro wrote:

I saw there is a new driver for sqlserver 2005 in the 1.2.0alpha1 release but I haven't try it yet.

Yea, I also saw that. But in the latest release version NHibernate 1.0.2 there is only dialect for SQL Server 2000 instead for 2005. That's why I'm asking. According to Gert's reply, it seems that the dialect 2000 can also work for 2005. I'll try and file a report next week.

Thanks for all your replies. Wish you have a nice weekend!

FritFrut · **Joined:** Mon Apr 24, 2006 1:43 pm **Posts:** 22

You can do something like this:
* Create a new project (let's call it Sql2005Dialect) for the SQL 2005 dialect
* put only MsSql2005Dialect.cs in it
* add the refernce to NHibernate
* reference this Sql2005Dialect project (or just the .dll) in your main project
* add something like:
<add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2005Dialect, Sql2005Dialect"/>
in your .config file

HTH, Tom