你的位置:首页 > ASP.net教程

[ASP.net教程]Dapper学习笔记(4)


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     }