NHibernate连多个数据库，NHibernate X-Factories

水深无声 2022-05-19 00:45 172阅读 0赞

# NHibernate X-Factories v1.2.0 #

NHibernate X-Factories allow you to combine multiple .cfg.xml into one. X-Factories does this by allowing each session-factory to be named and refer to them individually by name. This gives a cleaner and less verbose configuration for using NHiberate between multiple databases.

## Setup ##

Setup is really quite simple. Just add the schema, include the extension and you're good to go.

Adding the Schema

1.  Include the schema in your Project, Solution, or Visual Studios XML Schemas folder on your computer. Should be something similar to `%ProgramFiles%\Microsoft Visual Studio 10.0\Xml\Schemas`.
2.  Change the `xmlns` attribute of the `hibernate-configuration` element in your .cfg.xml to `urn:nhibernate-configuration-2.2-x-factories`.
3.  Change `hibernate-configuration` element `hibernate-configuration-x-factories`.
4.  Give the `session-factory` element a name and create as many `session-factory` elements as you like.

Including the Extension

1.  Open your Visual Studio project that already has NHibernate included.
2.  Copy the `ConfigurationExtensions.cs` into the project.

Note: Visual Studio Website projects might require that the extension be located in the `App_Code` folder.

XFactoriesExtensions.cs

//--------------------------------------------------------------------------------------------  
// NHibernate-X-Factories v1.2.0, Copyright 2014 roydukkey, 2014-10-14 (Tue, 14 Oct 2014).  
// Dual licensed under the MIT (http://www.roydukkey.com/mit) and  
// GPL Version 2 (http://www.roydukkey.com/gpl) licenses.  
//--------------------------------------------------------------------------------------------  
  
  
namespace NHibernate.Cfg  
\{  
using ConfigurationSchema;  
using System;  
using System.IO;  
using System.Xml;  
  
  
public static class XFactoriesExtensions  
\{  
public const string CONFIG\_MUTATION\_SUFFIX = "-x-factories";  
private const string CHILD\_PREFIX\_PATH = CfgXmlHelper.CfgNamespacePrefix + ":";  
private const string ROOT\_PREFIX\_PATH = "//" + CHILD\_PREFIX\_PATH;  
  
  
/// <summary>  
/// Configure NHibernate from a specified session-factory.  
/// </summary>  
/// <param name="config"></param>  
/// <param name="fileName">System location of '.cfg.xml' configuration file.</param>  
/// <param name="factoryName">Name value of the desired session-factory.</param>  
/// <returns></returns>  
public static Configuration Configure(this Configuration config, string fileName, string factoryName)  
\{  
// Load Configuration XML  
XmlDocument doc = new XmlDocument();  
doc.Load(fileName);  
  
  
return config.Configure(PrepareConfiguration(doc, factoryName));  
\}  
/// <summary>  
/// Configure NHibernate from a specified session-factory.  
/// </summary>  
/// <param name="config"></param>  
/// <param name="textReader">The XmlReader containing the hibernate-configuration.</param>  
/// <param name="factoryName">Name value of the desired session-factory.</param>  
/// <returns></returns>  
public static Configuration Configure(this Configuration config, XmlReader textReader, string factoryName)  
\{  
// Load Configuration XML  
XmlDocument doc = new XmlDocument();  
doc.Load(textReader);  
  
  
return config.Configure(PrepareConfiguration(doc, factoryName));  
\}  
/// <summary>  
/// Parses the configuration xml and ensures the target session-factory is the only one included.  
/// </summary>  
/// <param name="doc">The XmlDocument containing the hibernate-configuration.</param>  
/// <param name="factoryName">Name value of the desired session-factory.</param>  
/// <returns></returns>  
private static XmlTextReader PrepareConfiguration(XmlDocument doc, string factoryName)  
\{  
  
  
// Add Proper Namespace  
XmlNamespaceManager namespaceMgr = new XmlNamespaceManager(doc.NameTable);  
namespaceMgr.AddNamespace(CfgXmlHelper.CfgNamespacePrefix, CfgXmlHelper.CfgSchemaXMLNS + CONFIG\_MUTATION\_SUFFIX);  
  
  
// Query Elements  
XmlNode nhibernateNode = doc.SelectSingleNode(ROOT\_PREFIX\_PATH + CfgXmlHelper.CfgSectionName + CONFIG\_MUTATION\_SUFFIX, namespaceMgr);  
  
  
if (nhibernateNode != null) \{  
if (nhibernateNode.SelectSingleNode(ROOT\_PREFIX\_PATH + "session-factory\[@name='" + factoryName + "'\]", namespaceMgr) != default(XmlNode))  
foreach (XmlNode node in nhibernateNode.SelectNodes(ROOT\_PREFIX\_PATH + "session-factory\[@name!='" + factoryName + "'\]", namespaceMgr))  
nhibernateNode.RemoveChild(node);  
else  
throw new Exception(String.Format("<session-factory name=\\"\{0\}\\"> element was not found in the configuration file.", factoryName));  
\}  
else  
throw new Exception(String.Format("<\{1\}\{0\} xmlns=\\"\{2\}\{0\}\\"> element was not found in the configuration file.", CONFIG\_MUTATION\_SUFFIX, CfgXmlHelper.CfgSectionName, CfgXmlHelper.CfgSchemaXMLNS));  
  
  
return new XmlTextReader(new StringReader(nhibernateNode.OuterXml.Replace(CONFIG\_MUTATION\_SUFFIX, "")));  
\}  
  
  
\}  
\}

## Usage ##

<?xml version="1.0" encoding="utf-8" ?>
    <hibernate-configuration-x-factories xmlns="urn:nhibernate-configuration-2.2-x-factories">
    
        <session-factory name="Development">
            <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
            <property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
            <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
            <property name="connection.connection_string">
                Server=dsql01;DataBase=dbDev;uid=nhDeveloper;pwd=pass1234
            </property>
    
            <property name="show_sql">true</property>
    
            <mapping assembly="DataLayer" />
        </session-factory>
    
        <session-factory name="Production">
            <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
            <property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
            <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
            <property name="connection.connection_string">
                Server=psql02;DataBase=dbDev;uid=nhDeveloper;pwd=pass5678
            </property>
    
            <property name="show_sql">false</property>
    
            <mapping assembly="DataLayer" />
        </session-factory>
    
    </hibernate-configuration-x-factories>

NHibernate.Cfg.Configuration config = new NHibernate.Cfg.Configuration();
    config
        .Configure(HostingEnvironment.MapPath("~/nhibernate.cfg.xml"), "Development")
        .BuildSessionFactory();

## Support ##

Required

*  .Net 3.5 ≥
 *  NHibernate ([http://nhforge.org/Default.aspx][http_nhforge.org_Default.aspx])

Optional

*  [Configuration from Web.Config][]

参照网址：[http://cnblogs.com/dawenyang/p/7966850.html][http_cnblogs.com_dawenyang_p_7966850.html]

源码网址：[https://github.com/roydukkey/NHibernate-X-Factories][https_github.com_roydukkey_NHibernate-X-Factories]

[http_nhforge.org_Default.aspx]: http://nhforge.org/Default.aspx
[Configuration from Web.Config]: https://github.com/roydukkey/NHibernate-X-Factories/wiki/Configuration-from-Web.Config
[http_cnblogs.com_dawenyang_p_7966850.html]: http://cnblogs.com/dawenyang/p/7966850.html
[https_github.com_roydukkey_NHibernate-X-Factories]: https://github.com/roydukkey/NHibernate-X-Factories