本来是想通过 TransactionScope
来实现分布式事务的。
ORM 使用的是 FluentData 。
测试代码
using (var ts = new TransactionScope())
{
using (var db_wirte = new DbContext().ConnectionString(CONN_WRITE, new SqlServerProvider()).UseTransaction(true))
{
db_wirte.Insert("Table_A", new TestModel() {
Guid = Guid.NewGuid(),
Name = "测试数据",
CreateTime = DateTime.Now,
ModifyTime = DateTime.Now,
}).AutoMap().Execute();
using (var db_prod = new DbContext().ConnectionString(CONN_PROD, new SqlServerProvider()).UseTransaction(true))
{
db_prod.Insert("Table_B", new TestModel()
{
Guid = Guid.NewGuid(),
Name = "测试数据",
CreateTime = DateTime.Now,
ModifyTime = DateTime.Now,
}).AutoMap().Execute();
db_prod.Commit();
}
db_wirte.Commit();
}
ts.Complete();
}