.net 多个数据库事务处理

最新推荐文章于 2024-04-11 15:24:21 发布

sandea

最新推荐文章于 2024-04-11 15:24:21 发布

阅读量214

点赞数

分类专栏：数据库高级操作

本文链接：https://blog.csdn.net/sandea/article/details/10534595

版权

数据库高级操作专栏收录该内容

47 篇文章 0 订阅

订阅专栏

TranscationScope用法示例
//标记是否已执行接口库中的操作
bool isYiZhiXingInterface = false;
using (TransactionScope transScope = new TransactionScope())
{
    DataBase dbLocal = new DataBase(_connectionString);
    DataBase dbInterface = new DataBase(_connectionStringInterface);
    try
    {
        dbLocal.BeginTrans();
        dbInterface.BeginTrans();
        dbLocal.RunSqlNonQuery_Trans(strSql);
        dbInterface.RunSqlNonQuery_Trans(strSqlInterface);
        isYiZhiXingInterface = true;
    }
    catch(System.Da ta.SqlClient.SqlException ex)
    {
        dbLocal.RollBack();
        if (isYiZhiXingInterface)
            dbInterface.RollBack();
        dbLocal.Dispose();
        dbInterface.Dispose();
        throw ex;
    }
    dbLocal.Commit();
    dbInterface.Commit();
    transScope.Complete();
    dbLocal.Dispose();
    dbInterface.Dispose();
    transScope.Dispose();
}