CREATE PROCEDURE [dbo].[QueryMember]
@MemberId varchar(50)='',
@Name varchar(50)=''
AS
BEGIN
SELECT * FROM Member where MemberID=@MemberId and Name=@Name;
END
public void UseStoredProcedure()
{
var info = Database.Query<int>("QueryMember", new
{
MemberId = "20192225",
Name = "张三"
},
commandType: CommandType.StoredProcedure);
}
带输入输出存储过程的使用
CREATE PROCEDURE [dbo].[QueryMember]
@MemberId varchar(50)='',
@Name varchar(50)='',
@errorFlag int output, --错误标志
@errorMsg varchar(200) output --错误信息
AS
BEGIN
SELECT * FROM Member where MemberID=@MemberId and Name=@Name;
select @errorflag=0,@errormsg='查询成功'
END
只带输入参数存储过程的使用CREATE PROCEDURE [dbo].[QueryMember] @MemberId varchar(50)='',@Name varchar(50)=''ASBEGIN SELECT * FROM Member where MemberID=@MemberId and Name=@Name;ENDpublic void UseStore...