Castle ActiveRecord 连接各种数据引擎的配置文件归纳

最新推荐文章于 2019-10-14 15:42:38 发布

CodingSir

最新推荐文章于 2019-10-14 15:42:38 发布

阅读量1.6k

点赞数

文章标签： activerecord 引擎 string 数据库 class sql server

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 >