我有以下SQL存储过程:
但我总是收到以下错误提示。
任何帮助都会受到高度赞赏。
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetNextNumberTest]
@NEWNUMBER varchar(100) OUTPUT
AS
BEGIN
SET NOCOUNT ON;
SET @NEWNUMBER = 'ABC00001'
RETURN 1
END
我正在尝试使用dapper读取NENUMBER值,以下是我的代码:
private string GetNextNumber()
{
var dynamicParams = new DynamicParameters();
dynamicParams.Add("rval", DbType.Int32, direction: ParameterDirection.ReturnValue);
dynamicParams.Add("NEWNUMBER", DbType.String, direction: ParameterDirection.Output);
var data = db.QueryMultiple("GetNextNumberTest", dynamicParams, commandType: CommandType.StoredProcedure);
var result = dynamicParams.Get<string>("NEWNUMBER");
return result;
}
但我总是收到以下错误提示。
An exception of type 'System.Data.SqlClient.SqlException' occurred in Dapper.dll but was not handled in user code
Additional information: Error converting data type varchar to int.
任何帮助都会受到高度赞赏。