There is already an open DataReader associated with this Command which must be closed first的错误解决办法

最新推荐文章于 2023-11-27 14:43:06 发布
原创 最新推荐文章于 2023-11-27 14:43:06 发布 · 6.9k 阅读 · 4 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
标签
#command #database #insert #server
本文介绍了解决在使用SqlDataReader后尝试执行其他SqlCommand操作时出现的错误的方法。通过在ConnectionString中添加参数“MultipleActiveResultSets”并设置其值为true，可以避免错误的发生。

开发板推荐：天空星STM32F407VET6开发板

超高性价比 STM32主控 | 超高主频 | 一板兼容百芯 | 比赛神器 | 沉金彩色丝印

点击查看

执行SqlDataReader.Read之后，如果还想用另一个SqlCommand执行Insert或者Update操作的话，会得到一个错误提示：There is already an open DataReader associated with this Command which must be closed first.


解决方法是在ConnectionString中加上一个参数“MultipleActiveResultSets”, 将其值设置为true。

 

 

开发板推荐：天空星STM32F407VET6开发板

超高性价比 STM32主控 | 超高主频 | 一板兼容百芯 | 比赛神器 | 沉金彩色丝印

点击查看
hjzdhr
关注
已有打开的与此命令相关联的DataReader,必须首先将它关闭。对于此异常的理解
01-20
首先声明以下几点： 1、也许讲解有点初级，希望高手不要“喷”我，因为我知道并不是每一个人都是高手，我也怕高手们说我装13； 2、如有什么不对的地方，还希望大家指出，一定虚心学习； 3、本文属于作者原创，尊重他人劳动成果，转载请注明作者，谢谢。 下面开讲： 　　开始在遇到此问题的时候我也在网上查了很多资料，貌似没找到什么好的解决方法，然后我就开始调试程序，我发现有的时候运行不报错，有的时候运行报错，这就很纠结了，但是后来我发现我把ASP.NET Development Server – 端口 xxx退出，然后再运行程序就不报错了…我以为是好了，可以后来我有发现一个问题，只要端口没关或者程序运行时
EF "There is already an open DataReader associated with this Command which must be closed first."
weixin_33895516的博客
01-19 5389
1.出现问题 场景1：在插入数据之前，先进行判断是否存在 执行SqlDataReader.Read之后，如果还想用另一个SqlCommand执行Insert或者Update操作的话， 会得到一个错误提示：There is already an open DataReader associated with this Command which must ...
使用ef core时提示There is already an open DataReader associated with this Connection which must be closed
你要明白，任何问题都不是孤立存在的，一定有人曾经遇到过，并且已经有更好的解决办法了，只是我还不知道。我不应该在黑暗中独自前行，去重新发明轮子，也许我的顿悟，只是别人的基本功！我应该要站在巨人的肩膀上，学习更成熟的经验和方法，然后再来解决这个问题
11-27 3044
使用ef core时提示There is already an open DataReader associated with this Connection which must be closed
C#操作数据库的错误 There is already an open DataReader associated with this Connection which must be closed
热门推荐
KieSnow的博客
06-26 3万+
在进行数据库存储时，遇到错误：“MySql.Data.MySqlClient.MySqlException”类型的异常在 MySql.Data.dll 中发生，但未在用户代码中进行处理。 其他信息: There is already an open DataReader associated with this Connection which must be closed first.即已有打...
issue--C#--SQLKATA
qq_37233070的博客
08-24 1030
例如：dbContext.User.Where(x=>x.Age== 18);需要释放掉上面的DataReader，后面转ToList（）即可。将new Query()写在其他要调dbContext的后面。：在报错方法之前使用了一个未释放的IQueryable类型，
"There is already an open DataReader associated with this Command which must be closed first"问题的解决
08-08 4146
遇到了如题的问题，解决后把自己犯的错误共享出来， 希望对大家有帮助。首先看我一开始写的代码：IDataReader reader = db.Command.ExecuteReader();if (reader.Read()) {    return reader[0].ToString();}这段代码的本意是根据一条sql查出一行记录（能够保证最多只查出一条），如果有记录，则把某个字段的值作为函数
There is already an open DataReader associated with this Command which must be closed first
weixin_33836223的博客
11-12 319
为什么80%的码农都做不了架构师？>>> ...
There is already an open DataReader associated with this Connection which must be closed first
diaohunang4905的博客
09-18 426
最近在写WebApi接口，遇到一些问题，总结一下。这些问题未必跟WebApi有关系，比较琐碎。 总结列表： 1. There is already an open DataReader associated with this Connection which must be closed first 2. npm install 失败 3...
Asp.net Core :Already an open DataReader associated with this Connection which must be closed
荒野
01-19 677
C# Asp.NetCore 报错There is already an open DataReader associated with this Connection which must be closed first. 已有打开的与此命令相关联的DataReader，必须首先将它关闭。 报错语段详情 百度之后问题已经解决 https://www.mmbyte.com/article/43100.html 其实是 foreach(var user in userManager...
LINQ: There is already an open DataReader associated with this Command which must be closed first
shanyou的专栏
05-12 2211
在Linq to SQL和Entity Framework，使用Linq查询数据的时候会出现错误：There is already an open DataReader associated with this Command which must be closed first 。解决方案：在数据库连接串上添加MultipleActiveResultSets=true。Fi
There is already an open DataReader associated with this Connection which must be closed first.问题记录
世界既不黑也不白，而是一道精致的灰。
10-14 539
There is already an open DataReader associated with this Connection which must be closed first.问题记录 当进行两次链接报错 public async Task<IActionResult> ManageUserRoles([FromQuery] string userId) { //1.第一次链接 var user = await _user
There is already an open DataReader associated with this Connection which must be closed first.
qq_43786444的博客
09-07 601
There is already an open DataReader associated with this Connection which must be closed first.
There is already an open DataReader associated with this Command which must be closed first." except...
weixin_34242509的博客
11-12 390
Fixing the "There is already an open DataReader associated with this Command which must be closed first." exception in Entity Framework 下面代码可能会报如标题所示错误 var contacts = from c in db.Contact ...
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值