Question

ibatis.net调用存储过程出现错误This SQL map does not contain a MappedStatement named IsUserNameExis

<prucedure id="IsUserNameExists" patameterClass="String" resultClass="Boolean">
Exec [dbo].[IsUserNameExists] #UserName#
</prucedure>

C#

public bool IsUserNameExists(string userName)
{
SecUtility.CheckParameter(ref userName, true, true, true, 0, "userName");
return SqlMapper.QueryForObject<bool>("IsUserNameExists", userName);
}

存储过程
USE [signin]
GO

/****** Object: StoredProcedure [dbo].[IsUserNameExists] Script Date: 07/19/2013 16:28:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[IsUserNameExists]
@UserName nvarchar(256)
AS
BEGIN
IF (EXISTS (SELECT [signin].[dbo].[User].* FROM [signin].[dbo].[User] WHERE [UserName] like '%'+@UserName+'%'))
RETURN(1)
ELSE
RETURN(0)
END

GO

Answer 1

sqlmap配置有错误吧