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

 

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 >
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值