数据读取器具有多个字段。多个字段对于存储过程中的EDM原语或枚举类型无效

最新推荐文章于 2022-09-07 18:02:21 发布

qq874655551

最新推荐文章于 2022-09-07 18:02:21 发布

阅读量1.3k

点赞数

分类专栏： c#基础文章标签： EF 存储过程

本文链接：https://blog.csdn.net/wanglui1990/article/details/81007266

版权

c#基础专栏收录该内容

13 篇文章 0 订阅

订阅专栏

报错代码：

SqlParameter voteFrom = new SqlParameter("@voteFrom", workFlow.VoteFrom);
SqlParameter voteTo = new SqlParameter("@voteTo", workFlow.VoteTo);
SqlParameter result = new SqlParameter("@result", SqlDbType.NVarChar,50);
result.Direction = ParameterDirection.Output;

context.Database.SqlQuery<string>("exec [workflow_CheckAccount] @voteFrom,@voteTo,@result out", voteFrom, voteTo,result).FirstOrDefault();//报错行。
checkResult =(string)result.Value;

换成下面方法通过：

List<SqlParameter> paramArray = new List<SqlParameter>();
paramArray.Add(new SqlParameter("@voteFrom", workFlow.VoteFrom));
paramArray.Add(new SqlParameter("@voteTo", workFlow.VoteTo));

SqlParameter param = new SqlParameter("@result", SqlDbType.NVarChar, 50);
param.Direction = ParameterDirection.Output;
paramArray.Add(param);
try
{
    context.Database.ExecuteSqlCommand("EXEC [workflow_CheckAccount] @voteFrom,@voteTo,@result out", paramArray.ToArray());
}
catch (Exception ex)
{
    throw;
}
checkResult = (string)paramArray[2].Value;