NHibernate学习之二——.cfg.xml配置大全（数据库连接配置）

一、sql2000/2005.cfg.xml

NHibernate.Connection.DriverConnectionProvider

NHibernate.Dialect.MsSql2000Dialect/MsSql2005Dialect

NHibernate.Driver.SqlClientDriver

Server=.;Initial Catalog=dbname;User Id=sa;Password=*****

*************************************************************************************************************************************

二、Mysql.cfg.xml

NHibernate.Connection.DriverConnectionProvider

NHibernate.Driver.MySqlDataDriver

Database=test;Data Source=.;User Id=blah;Password=blah

NHibernate.Dialect.MySQLDialect

*************************************************************************************************************************************

三、Access.cfg.xml

NHibernate.Connection.DriverConnectionProvider

NHibernate.JetDriver.JetDialect, NHibernate.JetDriver

NHibernate.JetDriver.JetDriver, NHibernate.JetDriver

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FileName.mdb

*************************************************************************************************************************************

4、Oracle.cfg.xml

NHibernate.Connection.DriverConnectionProvider

NHibernate.Driver.OracleDataClientDriver

User ID=id;Password=pw;Data Source=requ;Pooling=true;Connection Lifetime=180;Connection Timeout=30;Min Pool Size=2;Max Pool Size=10;Incr Pool Size=2;

NHibernate.Dialect.Oracle10gDialect/Oracle9iDialect

true

*************************************************************************************************************************************

5、Firebird.cfg.xml

NHibernate.Connection.DriverConnectionProvider

NHibernate.Driver.FirebirdClientDriver

ReadCommitted

Server=localhost;

Database=C:\nhibernate.fdb;

User=SYSDBA;Password=masterkey

false

NHibernate.Dialect.FirebirdDialect

true

444

true 1, false 0, yes 1, no 0

*************************************************************************************************************************************

6、Postgrel.cfg.xml

NHibernate.Connection.DriverConnectionProvider

NHibernate.Driver.NpgsqlDriver

Server=localhost;initial catalog=nhibernate;User ID=nhibernate;Password=********;

NHibernate.Dialect.PostgreSQLDialect

*************************************************************************************************************************************

7、DB2.cfg.xml

NHibernate.Connection.DriverConnectionProvider

NHibernate.Driver.OdbcDriver

driver={IBM DB2 ODBC DRIVER};Database=db;hostname=host;port=port;protocol=TCPIP; uid=uid; pwd=pwd

true

NHibernate.Dialect.DB2Dialect

true

*************************************************************************************************************************************

8、SQLite.cfg.xml

NHibernate.Connection.DriverConnectionProvider

NHibernate.Driver.SQLiteDriver

Data Source=nhibernate.db;Version=3

NHibernate.Dialect.SQLiteDialect

true=1;false=0