core 3.1.8 多数据库事务、分布式事务

最新推荐文章于 2023-04-01 11:18:20 发布

GoToDinner

最新推荐文章于 2023-04-01 11:18:20 发布

阅读量1.1k

点赞数

分类专栏： core 文章标签： c#

本文链接：https://blog.csdn.net/u010690818/article/details/109988342

版权

core 专栏收录该内容

13 篇文章

订阅专栏

            #region 事务

            if (false)
            {
                //这种好像不行会报，"This platform does not support distributed transactions."

                using (TransactionScope trans = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
                {
                    try
                    {


                        await _lianCallContext.SaveChangesAsync();
                        await _lianCallManageContext.SaveChangesAsync();
                        trans.Complete();
                    }
                    catch (Exception ex)
                    {
                        Transaction.Current.Rollback();
                        return await Task.FromResult(resposeData.Error(ex.Message));
                    }

                }
            }
            else
            {

                var tran_lianCall = _lianCallContext.Database.BeginTransaction();
                try
                {
                    await _lianCallContext.SaveChangesAsync();
                    //没问题就再创建另一个数据库事务
                    var tran_lianCallManage = _lianCallManageContext.Database.BeginTransaction();
                    try
                    {
                        await _lianCallManageContext.SaveChangesAsync();
                        await tran_lianCallManage.CommitAsync();
                    }
                    catch (Exception ex)
                    {
                        await tran_lianCallManage.RollbackAsync();
                        await tran_lianCall.RollbackAsync();
                        //return await Task.FromResult(resposeData.Error(ex.Message));
                    }
                    finally
                    {
                        await tran_lianCallManage.DisposeAsync();
                    }
                    await tran_lianCall.CommitAsync();
                }
                catch (Exception ex)
                {
                    await tran_lianCall.RollbackAsync();
                    //return await Task.FromResult(resposeData.Error(ex.Message));
                    throw ex;
                }
                finally
                {
                    await tran_lianCall.DisposeAsync();
                }

            }

            #endregion