SqlSugar学习笔记六——事务

实体类

  ///<summary>
    ///
    ///</summary>
    [SugarTable("Student")]
    public partial class Student
    {
           public Student(){


           }
           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:False
           /// </summary>           
           [SugarColumn(IsPrimaryKey=true,IsIdentity=true)]
           public int Id {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public int? SchoolId {get;set;}

           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string Name {get;set;}

    }

事务

/// <summary>
/// 租户事务
/// </summary>
public static class TenantTransactions
{
    /// <summary>
    /// 多租户事务
    /// </summary>
    public static void Show()
    {
        List<ConnectionConfig> connectionconfiglist = new List<ConnectionConfig>()
        {
            new ConnectionConfig(){ ConfigId="1", DbType=DbType.SqlServer,ConnectionString="Data Source=DESKTOP-VF73RDU;Initial Catalog=CustomerDB;Persist Security Info=True;User ID=sa;Password=sa123",IsAutoCloseConnection=true},

            new ConnectionConfig(){ ConfigId="2", DbType=DbType.SqlServer,ConnectionString="Data Source=DESKTOP-VF73RDU;Initial Catalog=CustomerDB_New;Persist Security Info=True;User ID=sa;Password=sa123",IsAutoCloseConnection=true}
        };
        using (SqlSugarClient db = new SqlSugarClient(connectionconfiglist))
        {
            SqlSugarProvider provoder1 = db.GetConnection("1");
            SqlSugarProvider provoder2 = db.GetConnection("2");
            try
            {
                db.BeginTran(); //开启事务
                provoder1.Insertable(new Student() { Name = "Richard老师--租户20220525", SchoolId = 1 }).ExecuteCommand();
                provoder2.Insertable(new Student() { Name = "Richard老师--租户20220525Richard老师--租户20220525Richard老师--租户20220525Richard老师--租户20220525Richard老师--租户20220525Richard老师--租户20220525Richard老师--租户20220525Richard老师--租户20220525Richard老师--租户20220525Richard老师--租户20220525Richard老师--租户20220525Richard老师--租户20220525Richard老师--租户20220525", SchoolId = 1 }).ExecuteCommand();

                db.CommitTran();
            }
            catch (Exception)
            {
                db.RollbackTran();
            }
            finally
            {
                GC.Collect();
            }
        }
    }


    /// <summary>
    /// 事务
    /// </summary>
    public static void TenantShow()
    {
        List<ConnectionConfig> connectionconfiglist = new List<ConnectionConfig>()
        {
            new ConnectionConfig(){DbType=DbType.SqlServer,ConnectionString="Data Source=DESKTOP-VF73RDU;Initial Catalog=CustomerDB;Persist Security Info=True;User ID=sa;Password=sa123",IsAutoCloseConnection=true}
        };
        using (SqlSugarClient db = new SqlSugarClient(connectionconfiglist))
        {
            try
            {
                db.AsTenant().BeginTran();
                db.Insertable(new Student() { Name = "Richard老师--租户 New", SchoolId = 1 }).ExecuteCommand();
                db.Insertable(new Student() { Name = "Richard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 New", SchoolId = 1 }).ExecuteCommand();
                db.AsTenant().CommitTran();
            }
            catch (Exception)
            {
                db.AsTenant().RollbackTran();
            }
            finally
            {
                GC.Collect();
            }

        }
    }


    /// <summary>
    /// 发生异常自动回滚
    /// </summary>
    public static void UseTranShow()
    {
        try
        {
            List<ConnectionConfig> connectionconfiglist = new List<ConnectionConfig>()
            {
                new ConnectionConfig(){DbType=DbType.SqlServer,ConnectionString="Data Source=DESKTOP-VF73RDU;Initial Catalog=CustomerDB;Persist Security Info=True;User ID=sa;Password=sa123",IsAutoCloseConnection=true}
            };
            using (SqlSugarClient db = new SqlSugarClient(connectionconfiglist))
            {
                using (SqlSugarTransaction tran = db.UseTran())
                {
                    db.Insertable(new Student() { Name = "Richard老师--租户 New", SchoolId = 1 }).ExecuteCommand();
                    db.Insertable(new Student() { Name = "Richard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 New", SchoolId = 1 }).ExecuteCommand();
                    tran.CommitTran();
                }
            }
        }
        catch (Exception)
        {

        }
    }



    /// <summary>
    /// 事务语法糖写法
    /// </summary>
    public static void UseTranShowNew()
    {

        List<ConnectionConfig> connectionconfiglist = new List<ConnectionConfig>()
        {
            new ConnectionConfig(){DbType=DbType.SqlServer,ConnectionString="Data Source=DESKTOP-VF73RDU;Initial Catalog=CustomerDB;Persist Security Info=True;User ID=sa;Password=sa123",IsAutoCloseConnection=true}
        };
        using (SqlSugarClient db = new SqlSugarClient(connectionconfiglist))
        {
            DbResult<bool> result = db.UseTran(() =>
                                               {
                                                   db.Insertable(new Student() { Name = "Richard老师--租户 New", SchoolId = 1 }).ExecuteCommand();
                                                   db.Insertable(new Student() { Name = "Richard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 NewRichard老师--租户 New", SchoolId = 1 }).ExecuteCommand();
                                                   return true;// 返回值等行res.Data
                                               });

            if (result.Data == false) //返回值为false
            {
                //result.Data 业务的返回值 
                //如果是上面的逻辑 result.Data==true肯定业务成功并且事务成功
                //if(result.IsSuccess==false)//事务执行了回滚
                //if(result.IsSuccess==true)//事务提交完成
            }
        }

    }

}