There is already an open DataReader associated with this Connection which must be closed first

最新推荐文章于 2024-08-26 16:02:12 发布
转载 最新推荐文章于 2024-08-26 16:02:12 发布 · 197 阅读 · 0 ·
CC 4.0 BY-SA版权
原文链接：http://www.cnblogs.com/hww9011/p/3611592.html

本文介绍了一个在MVC4中使用EF Linq进行foreach列表循环时遇到的报错问题：“There is already an open DataReader associated with this Connection which must be closed first”。通过简单修改将Model直接改为Model.ToList()解决了此问题。
使用MVC4 EF Linq获取foreach列表循环的时候遇到了如下的问题：报错提示
There is already an open DataReader associated with this Connection which must be closed first

解决方法如下红色所示：
@foreach (var item in Model.ToList())
{
  @Html.ActionLink(@item.user.nickname + "(微信)", "../Mess/MessInfo", new { id = item.id })
}
将Model改成Model.ToList()的就ok了

 

转载于:https://www.cnblogs.com/hww9011/p/3611592.html

dengzhan3753
关注
已有打开的与此命令相关联的DataReader,必须首先将它关闭。对于此异常的理解
01-20
首先声明以下几点： 1、也许讲解有点初级，希望高手不要“喷”我，因为我知道并不是每一个人都是高手，我也怕高手们说我装13； 2、如有什么不对的地方，还希望大家指出，一定虚心学习； 3、本文属于作者原创，尊重他人劳动成果，转载请注明作者，谢谢。 下面开讲： 　　开始在遇到此问题的时候我也在网上查了很多资料，貌似没找到什么好的解决方法，然后我就开始调试程序，我发现有的时候运行不报错，有的时候运行报错，这就很纠结了，但是后来我发现我把ASP.NET Development Server – 端口 xxx退出，然后再运行程序就不报错了…我以为是好了，可以后来我有发现一个问题，只要端口没关或者程序运行时
[已解决]There is already an open DataReader associated with this Connection which mu
a123_z的博客
10-12 1万+
今天程序报错：There is already an open DataReader associated with this Connection which mu…… 解决方案：在报错方法之前使用了一个未释放的IQueryable类型， 例如：dbContext.User.Where(x=>x.Age== 18); 需要释放掉上面的DataReader，后面转ToList（）即可。...
There is already an open DataReader associated with this Connection which must be closed first EF
NickWei1994的专栏
12-08 273
废话不多说，直接 上图，及解决办法。不过问题还不是太清楚到底为什么会出现这个情况。。。。。。。。。。 转载于:https://www.cnblogs.com/shihao316558512/p/9737050.html...
There is already an open DataReader associated with this Connection which must be closed first.
qq_43786444的博客
09-07 567
There is already an open DataReader associated with this Connection which must be closed first.
there is already an open DataReader associated with this Connection which must be closed first
04-19
好的，我现在需要帮助用户解决C#连接MySQL时出现的“DataReader already open”错误。首先，我要回顾用户提供的引用内容，看看里面提到的信息。引用[1]和[2]都提到了这个错误，用户已经尝试过使用using语句和关闭...
{"There is already an open DataReader associated with this Connection which must be closed first."}
07-09
> `{"There is already an open DataReader associated with this Connection which must be closed first."}` 这个错误的意思是：你正在尝试执行一个新的数据库查询（例如调用 `ExecuteReader`、`ExecuteNonQuery`...
MySqlTransaction transaction = Variable.Instance.BeginTransaction(); 报错：There is already an open DataReader associated with this Connection which must be closed first.
最新发布
10-30
首先，用户的问题是错误信息："There is already an open DataReader associated with this Connection which must be closed first." 当执行 `MySqlTransaction transaction = Variable.Instance.BeginTransaction...
MySql.Data.MySqlClient.MySqlException:“There is already an open DataReader associated with this Connection which must be closed first.”
06-20
在使用 `MySql.Data.MySqlClient` 库进行数据库操作时，如果遇到异常 `'There is already an open DataReader associated with this Connection which must be closed first'`，通常是由于在同一连接上同时执行多个...
使用ef core时提示There is already an open DataReader associated with this Connection which must be closed
你要明白，任何问题都不是孤立存在的，一定有人曾经遇到过，并且已经有更好的解决办法了，只是我还不知道。我不应该在黑暗中独自前行，去重新发明轮子，也许我的顿悟，只是别人的基本功！我应该要站在巨人的肩膀上，学习更成熟的经验和方法，然后再来解决这个问题
11-27 2905
使用ef core时提示There is already an open DataReader associated with this Connection which must be closed
MySqlException (0x80004005): 多线程中（There is already an open DataReader associated with this ）错误解决方案
编程技术探索者，分享C/C++、C#、Java、数据库等开发经验，聚焦实战技巧与AI兴趣，助力编程爱好者成长。
08-26 2379
MySql.Data.MySqlClient.MySqlException (0x80004005): There is already an open DataReader associated with this Connection which must be closed first. 解决 MySql.Data.MySqlClient.MySqlException (0x80004005) 错误，优化C#多线程数据库操作。
Asp.net Core :Already an open DataReader associated with this Connection which must be closed
荒野
01-19 654
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...
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.即已有打...
C#连接Mysql之There is already an open DataReader associated with this Connection which must be closed
m0_59051864的博客
11-01 1157
C#连接MySql数据库之报错:There is already an open DataReader associated with this Connection which must be closed first
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值