Spring.Net中配置多数据源
<db:provider id="CreditAndDebitsDbProvider"
provider="System.Data.SqlClient"
connectionString="Data Source=MARKT60\SQL2005;Initial Catalog=CreditsAndDebits;User ID=springqa;
Password=springqa"/>
<db:provider id="CreditDbProvider"
provider="System.Data.SqlClient"
connectionString="Data Source=MARKT60\SQL2005;Initial Catalog=Credits;User ID=springqa;
Password=springqa"/>
<object id="dbProviderDictionary" type="Spring.Collections.SynchronizedHashtable, Spring.Core">
<property name="['DbProvider1']" ref="CreditAndDebitsDbProvider"/>
<property name="['DbProvider2']" ref="CreditDbProvider"/>
</object>
<object id="DbProvider" type="Spring.Data.MultiDelegatingDbProvider, Spring.Data">
<property name="TargetDbProviders" ref="dbProviderDictionary"/>
<property name="DefaultDbProvider" value="CreditDbProvider"/>
</object>
代码中使用下列语句进行数据源切换
using Spring.Data.Common;