A,B,C主机上分别存放了DBa,DBb,DBc数据库,操作过程是将DBa中的a表和DBb中的b表的作连接的一些操作,然后将结果放入DBc的c表中, 原来我一直使用三个数据连接作,先存取这两个数据库到recordset,然后逐条记录进行循环,组合成一组新的纪录数组,然后再写入C主机的DBc中;3个数据库类型都是一致的,链接池是否支持这种数据操作?比如从A,B数据库中分别查询出临时表放入同一个连接池中,直接在连接池中用SQL操作临时表得到最终的结果表c,插入目标库C中;请各位高手赐教;
另外如果A,B不是同一种数据库的情况如何?
=============
另外如果A,B不是同一种数据库的情况如何?
=============
1
学习NHibernate的配置中是只有一个数据库连接的,当需要多个不同的数据库连接的时候,可以新增加一个xml配置文件(hibernate.cfg.xml),其内容如:
2
3
4
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.0" >
5
<session-factory name="NHibernate.Test">
6
<!-- properties -->
7
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
8
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
9
<property name="connection.connection_string">Server=localhost;initial catalog=nhibernate;Integrated Security=SSPI</property>
10
<property name="show_sql">false</property>
11
<property name="dialect">NHibernate.Dialect.MsSql2000Dialect</property>
12
<property name="use_outer_join">true</property>
13
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
14
<!-- mapping files -->
15
<mapping assembly="NHibernate.Examples" />
16
</session-factory>
17
18
</hibernate-configuration>
19![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
1
//代码类似于:
2
3
4
private void Config(string configXmlFile,Type[] types)
5
{
6
try
7
{
8
nConfig = new Configuration();
9
nConfig.Configure(configXmlFile);
10
11
for ( int i=0;i<types.Length;i++)
12
{
13
nConfig.AddClass(types[i]);
14
}
15
nSessionFactory = nConfig.BuildSessionFactory();
16
}
17
catch(Exception e)
18
{
19
throw e;
20
}
21
}
22![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)