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 }