Dapper学习笔记（四）-事务

 1         private void DapperTransaction() 2         { 3             using (IDbConnection con = OpenConnection()) 4             { 5                 IDbTransaction tran = con.BeginTransaction(); 6                 try 7                 { 8                     string query = "update T_Role set RoleName='开发主管' where RoleId=4";//更新一条记录 9                     con.Execute(query, null, tran, null, null);10                     //throw new Exception();11                     query = "delete from T_Role where RoleId=8";//删除一条记录12                     con.Execute(query, null, tran, null, null);13                     tran.Commit();14                 }15                 catch (Exception ex)16                 {17                     tran.Rollback();18                 }19             }20         }