Castle ActiveRecord学习实践(10)——使用多数据库

我们在开发中会遇到这样的情况，创建的ActiveRecord类在不同的数据库中，本文来看看Castle ActiveRecord如何处理这种情况。

比如我们有 DB1数据库，里面包含一个Articles表，DB2数据库，里面包含一个AppInfo表

首先，我们创建抽象基类

 

public abstract class DB1<T> : ActiveRecordBase<T>
{
}

 

 

public abstract class DB2<T> : ActiveRecordBase<T>
{
}

 

抽象基类里面什么都没有，只是个空架子

其次，创建具体类

[ActiveRecord("Articles")]
public class Article : DB1<Article>
{
    [PrimaryKey("id")]
    public int Id
    {
        get;
        set;
    }
    [Property("title")]
    public string Title
    {
        get;
        set;
    }
    [Property("text")]
    public string Text
    {
        set;
        get;
    }
}

[ActiveRecord]
public class AppInfo : DB2<AppInfo>
{
    [PrimaryKey("id")]
    public int Id
    {
        get;
        set;
    }
    [Property("appname")]
    public string AppName
    {
        get;
        set;
    }
    [Property("text")]
    public string Text
    {
        get;
        set;
    }
}

最后，配置文件

<activeRecord isWeb="true">
  <config type="Model.DB1`1,Model">
    <add key="hibernate.connection.driver_class" value="NHibernate.Driver.SqlClientDriver"/>
    <add key="proxyfactory.factory_class" value="NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle"/>
    <add key="dialect" value="NHibernate.Dialect.MsSql2005Dialect"/>
    <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
    <add key="connection.connection_string" value="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DB1.mdf;Integrated Security=True;User Instance=True"/>
  </config>
  <config type="Model.DB2`1,Model">
    <add key="hibernate.connection.driver_class" value="NHibernate.Driver.SqlClientDriver"/>
    <add key="dialect" value="NHibernate.Dialect.MsSql2005Dialect"/>
    <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
    <add key="connection.connection_string" value="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DB2.mdf;Integrated Security=True;User Instance=True"/>
    <add key="proxyfactory.factory_class" value="NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle"/>
  </config>
</activeRecord>

global类

protected void Application_Start(object sender, EventArgs e)
{
    IConfigurationSource source = ConfigurationManager.GetSection("activeRecord") as IConfigurationSource;

    Castle.ActiveRecord.ActiveRecordStarter.Initialize(System.Reflection.Assembly.Load("Model"), source);

}

这样就完成了

需要注意：DB1和DB2是泛型类，它指定的类型名称为  type="Model.DB1`1,Model"