MS SQL Databases supported by NHibernate.
SQL Server 2005 and 2000 are the primary databases used by the developers of NHibernate.
Configuration example:
<?xml version=”1.0″ ?>
<hibernate-configuration xmlns=”urn:nhibernate-configuration-2.2″ >
<session-factory>
<property name=”connection.provider”>NHibernate.Connection.DriverConnectionProvider</property>
<property name=”dialect”>NHibernate.Dialect.MsSql2005Dialect</property>
<property name=”connection.driver_class”>NHibernate.Driver.SqlClientDriver</property>
<property name=”connection.connection_string”>Server=(local);Initial Catalog=dbname;User Id=user;Password=********</property>
</session-factory>
</hibernate-configuration>
For SQL Server 2000, change the dialect to NHibernate.Dialect.MsSql2000Dialect.





