nhibernate 配置mysql_NHibernate 支持的数据库及配置参数

NHibernate is primarily tested on Microsoft SQL Server 2000. It is also known to work on these databases:

Microsoft SQL Server 2005/2000

SQL Server 2005 and 2000 are the primary databases used by the developers of NHibernate.

Configuration example:

NHibernate.Connection.DriverConnectionProvider

NHibernate.Dialect.MsSql2005Dialect

NHibernate.Driver.SqlClientDriver

Server=(local);Initial Catalog=dbname;User Id=user;Password=********

For SQL Server 2000, change the dialect to NHibernate.Dialect.MsSql2000Dialect

Issues

SQL Server sometimes ignores columns specified in ORDER BY clause of a query if they are not included in the SELECT  clause. This behavior is actually valid according to the SQL standard,  but may be surprising. For example, a query like this is not guaranteed  to be ordered correctly:

from Person p order by p.Company.Name

Oracle

Oracle 9i and 10g are supported, both using Microsoft driver (System.Data.OracleClient) and using Oracle driver (Oracle.Data.OracleClient).

Issues

Microsoft's  driver does not handle long character strings correctly. An error  happens in some circumstances when using a string of length 2000-4000 as  a pa