MS Access 数据库连接配置：


 <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />  

<add key="hibernate.dialect" value="NHibernate.JetDriver.JetDialect, NHibernate.JetDriver" />  

<add key="hibernate.connection.driver_class" value="NHibernate.JetDriver.JetDriver, NHibernate.JetDriver" />  

<add key="hibernate.connection.connection_string" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.mdb" />


MS SQL Server 2000 数据库连接配置：


< add  key ="hibernate.connection.driver_class"  value ="NHibernate.Driver.SqlClientDriver"   />

< add  key ="hibernate.dialect"                  value ="NHibernate.Dialect.MsSql2000Dialect"   />

< add  key ="hibernate.connection.provider"      value ="NHibernate.Connection.DriverConnectionProvider"   />

< add  key ="hibernate.connection.connection_string"  value ="Server=127.0.0.1;UID=sa;Password=***;Initial Catalog=test;Data Source=."   />


Oracle 数据库连接配置：


<activerecord>

    <config>

        <add key="hibernate.connection.driver_class" value="NHibernate.Driver.OracleClientDriver" />

        <add key="hibernate.dialect" value="NHibernate.Dialect.OracleDialect" />

        <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

        <add key="hibernate.connection.connection_string" value="Data Source=dm;User ID=dm;Password=dm;" />

    </config>

</activerecord>


MySQL 数据库连接配置：


<activerecord>

    <config>

        <add key="hibernate.connection.driver_class" value="NHibernate.Driver.MySqlDataDriver" />

        <add key="hibernate.dialect" value="NHibernate.Dialect.MySQLDialect" />

        <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

        <add key="hibernate.connection.connection_string" value="Database=test;Data Source=someip;User Id=blah;Password=blah" />

    </config>

</activerecord>


FireBird 数据库连接配置：


<activerecord>

    <config>

        <add key="hibernate.connection.driver_class" value="NHibernate.Driver.FirebirdDriver" />

        <add key="hibernate.dialect" value="NHibernate.Dialect.FirebirdDialect" />

        <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

        <add key="hibernate.connection.connection_string" value="Server=localhost;Database=d:/db.fdb;User=SYSDBA;password=masterkey;ServerType=1;Pooling=false" />

        <add key="hibernate.query.substitutions" value="true 1, false 0" />

    </config>

</activerecord>


PostgreSQL 数据库连接配置：


<activerecord>

    <config>

        <add key="hibernate.connection.driver_class" value="NHibernate.Driver.NpgsqlDriver" />

        <add key="hibernate.dialect" value="NHibernate.Dialect.PostgreSQLDialect" />

        <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

        <add key="hibernate.connection.connection_string" value="Server=localhost;initial catalog=nhibernate;User ID=nhibernate;Password=nhibernate;" />

    </config>

</activerecord>