接上一篇《》

 

0.存储过程

create proc p_login@Name nvarchar(16),@Password nvarchar(128),@result nvarchar(128) outputasbeginif(exists(select * from Users where Name=@Name and Password=@Password)) set @result='登陆成功'else set @result='用户名或密码错误'end

 

1.执行存储过程

IDbConnection conn = new SqlConnection(connStr);var pars = new DynamicParameters();pars.Add("@Name", "bj");pars.Add("@Password", "123456");pars.Add("@result", "", DbType.String, ParameterDirection.Output);conn.Execute("p_login", pars, commandType: CommandType.StoredProcedure);string result = pars.Get
      
       ("@result");
      

 

2.事务操作

IDbConnection conn = new SqlConnection(connStr);conn.Open();//手动打开IDbTransaction tran = conn.BeginTransaction();int result = conn.Execute("delete from users", transaction: tran);//将事务分配给命令if (result > 0)    tran.Rollback();else    tran.Commit();