首页 > 代码库 > 【转】NHibernate 各种数据库配置

【转】NHibernate 各种数据库配置

2024-07-17 21:47:00   220人阅读

转载自：http://terrylee.cnblogs.com/archive/2006/04/05/367381.html

 

自己只用了Oracle 可用！

 

三．常见的配置示例

Castle网站为我们提供的几个常见的配置示例
1．MS SQLServer

<activerecord>

    <config>

        <add key="hibernate.connection.driver_class" value="http://www.mamicode.com/NHibernate.Driver.SqlClientDriver" />

        <add key="hibernate.dialect" value="http://www.mamicode.com/NHibernate.Dialect.MsSql2000Dialect" />

        <add key="hibernate.connection.provider" value="http://www.mamicode.com/NHibernate.Connection.DriverConnectionProvider" />

        <add key="hibernate.connection.connection_string" value="http://www.mamicode.com/Data Source=.;Initial Catalog=test;UID=sa;Password=sa" />

    </config>

</activerecord>

 

2．Oracle

<activerecord>

    <config>

        <add key="hibernate.connection.driver_class" value="http://www.mamicode.com/NHibernate.Driver.OracleClientDriver" />

        <add key="hibernate.dialect" value="http://www.mamicode.com/NHibernate.Dialect.OracleDialect" />

        <add key="hibernate.connection.provider" value="http://www.mamicode.com/NHibernate.Connection.DriverConnectionProvider" />

        <add key="hibernate.connection.connection_string" value="http://www.mamicode.com/Data Source=dm;User ID=dm;Password=dm;" />

    </config>

</activerecord>

 

 

 

3．MySQL

 

<activerecord>

    <config>

        <add key="hibernate.connection.driver_class" value="http://www.mamicode.com/NHibernate.Driver.MySqlDataDriver" />

        <add key="hibernate.dialect" value="http://www.mamicode.com/NHibernate.Dialect.MySQLDialect" />

        <add key="hibernate.connection.provider" value="http://www.mamicode.com/NHibernate.Connection.DriverConnectionProvider" />

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

    </config>

</activerecord>

 

 

 

4．Firebird

 

<activerecord>

    <config>

        <add key="hibernate.connection.driver_class" value="http://www.mamicode.com/NHibernate.Driver.FirebirdDriver" />

        <add key="hibernate.dialect" value="http://www.mamicode.com/NHibernate.Dialect.FirebirdDialect" />

        <add key="hibernate.connection.provider" value="http://www.mamicode.com/NHibernate.Connection.DriverConnectionProvider" />

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

        <add key="hibernate.query.substitutions" value="http://www.mamicode.com/true 1, false 0" />

    </config>

</activerecord>

 

5．PostgreSQL

<activerecord>

    <config>

        <add key="hibernate.connection.driver_class" value="http://www.mamicode.com/NHibernate.Driver.NpgsqlDriver" />

        <add key="hibernate.dialect" value="http://www.mamicode.com/NHibernate.Dialect.PostgreSQLDialect" />

        <add key="hibernate.connection.provider" value="http://www.mamicode.com/NHibernate.Connection.DriverConnectionProvider" />

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

    </config>

</activerecord>

 


联系
我们