Spring.Net实现跨数据库服务层事务管理

在实际项目中用了Spring.Net框架之后，发现这框架在处理数据库事务上特别强大，声明式的数据库事务解放了一般开发人员对数据库事务操作的复杂处理。尤其是多数据库事务处理上，尤为显得更简便，几个简单的配置就能搞定。本篇文章对于如何用Spring.Net 2.0 + MVC 5.0搭建开发项目，就不再多赘述。直接上关键事务配置文件的代码:

<?xml version="1.0" encoding="utf-8" ?>
<objects
xmlns="http://www.springframework.net"
xmlns:db="http://www.springframework.net/database"
xmlns:tx="http://www.springframework.net/tx">
<description></description>
<db:provider
id="BaseDbProvider"
provider="System.Data.SqlClient"
connectionString="Data Source=YOOBABY-ZXRJ\ZXSOFT;User ID=sa;Password=123456;database=SYPT;"/>
<db:provider
id="BakDbProvider"
provider="System.Data.SqlClient"
connectionString="Data Source=YOOBABY-ZXRJ\ZXSOFT;User ID=sa;Password=123456;database=XNZH;"/>
<object
id="BaseDb"
type="Spring.Data.Generic.AdoTemplate, Spring.Data">
<property
name="DbProvider"
ref="BaseDbProvider"/>
<property
name="DataReaderWrapperType"
value="Spring.Data.Support.NullMappingDataReader, Spring.Data"/>
</object>
<object
id="BakDb"
type="Spring.Data.Generic.AdoTemplate, Spring.Data">
<property
name="DbProvider"
ref="BakDbProvider"/>
<property
name="DataReaderWrapperType"
value="Spring.Data.Support.NullMappingDataReader, Spring.Data"/>
</object>
<object
id="TransactionManager"
type="Spring.Data.Core.AdoPlatformTransactionManager, Spring.Data">
<property
name="DbProvider"
ref="BaseDbProvider"/>
</object>
<object
id="TransactionManager2"
type="Spring.Data.Core.AdoPlatformTransactionManager, Spring.Data">
<property
name="DbProvider"
ref="BakDbProvider"/>
</object>
<tx:attribute-driven
transaction-manager="TransactionManager"/>
<tx:attribute-driven
transaction-manager="TransactionManager2"/>
</objects>

如上数据事务配置文件中，定义了两个DbProvider , 两个AdoTempalate上下文，并正对两个DbProvider 都定义了数据事务.

dao层配置了相应代码:

<object
id="Dao.User"
type="HH.Application.Core.Dao.Impl.UserDao, HH.Application.Core">
<property
name="AdoTemplate"
ref="BaseDb"/>
</object>
<object
id="Dao.Role"
type="HH.Application.Core.Dao.Impl.RoleDao, HH.Application.Core">
<property
name="AdoTemplate"
ref="BakDb"/>
</object>