EF事务处理封装公用

最新推荐文章于 2024-06-21 16:42:10 发布

weixin_30656145

最新推荐文章于 2024-06-21 16:42:10 发布

阅读量179

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/Warmsunshine/p/9110762.html

版权

    /// <summary>
    /// EF事务封装 公用类
    /// </summary>
    public class TransactionCommon
    {
        DbContextTransaction Transaction = null;
        /// <summary>
        /// 数据库连接
        /// </summary>
        private readonly DefaultDbContext _DbContext = new DefaultDbContext();


        /// <summary>
        /// 开始事务
        /// </summary>
        public void BeginTransaction()
        {
            
            if (Transaction == null)
            {
                _DbContext.Database.BeginTransaction();
            }
            

        }

        /// <summary>
        /// 提交一个事务
        /// </summary>
        /// <returns></returns>
        public int Commit()
        {
            int result = 0;
            if (Transaction == null)
            {
                result += _DbContext.SaveChanges();
               
                DbContextTransaction transaction = _DbContext.Database.CurrentTransaction;
                if (transaction != null)
                {
                    transaction.Commit();
                    transaction.Dispose();
                    result += 1;
                }

            }
            return result;
        }

        /// <summary>
        /// 回滚一个事务
        /// </summary>
        public void Rollback()
        {

            if (Transaction == null)
            {
               
                DbContextTransaction transaction = _DbContext.Database.CurrentTransaction;
                if (transaction != null)
                {
                    transaction.Rollback();
                    transaction.Dispose();
                }
            }
            else
            {
                throw new Exception("事务异常");
            }
        }


    }