Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
1.2.0

I'm writing a db application.

The problem is that some of the database servers are SQL2000 and some are SQL2005.

I think that, in the future, the databases will all be upgraded to SQL2005, but I'm not SURE of this.

The database application will be relatively simple...just straight altering of tables.

My question is this:

Should I write the app using <property name="dialect">NHibernate.Dialect.MsSql2000Dialect</property> or <property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>?

Can I use both?

Hello!

You can only use "one dialact per Session" (=DB Connection) but you can freely switch between the different dialects when targeting different Servers. NHibernate will use the dialect you select to construct the correct querry for the target Platform. (e.g. To querry a recursive datastructure it will use a "connect by..." if you have an Oracle and a "CTE" if you target a sql2005 Server)

The "goal" of NHibernate is to make you no longer DB dependant. So you only need to change the configuration in order to use another DB (Some restrictions apply with ID Fields... e.g. a SQL Server wont support a sequence generator)

So short answer: Pick the right dialect for your server. A SQL2000 SHOULD work with a SQL2005, but you will miss out on some of the features...


Hope this helps