Spring.Net配置多数据源

来源：互联网发布：yankee candle 知乎编辑：程序博客网时间：2024/06/14 05:22

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;

MultiDelegatingDbProvider.CurrentDbProviderName = "DbProvider2"

0 0