旧系统dapper 1.4版本 动态参数老是飘红报错 只能用其他方式传参数

using (IDbConnection conn = new SqlConnection(ConnectionString))
{
string execSp = @"
DECLARE @return_value int,
@CompanyId int
EXEC[dbo].[cp_API_Supplier_InsertSupplier]
@CompanyName = N'" + companyName + "', @CompanyId = @CompanyId OUTPUT SELECT @CompanyId as N'@CompanyId'";

var comId = conn.ExecuteScalar<int>(execSp, null, null, null,null);

return comId;

}

原文地址:https://www.cnblogs.com/SpiritWalker/p/14053178.html