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 发布
阅读量502 收藏
点赞数
分类专栏： EF
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_43786444/article/details/100598606
版权

There is already an open DataReader associated with this Connection which must be closed first.
在这里插入图片描述

qq_43786444
关注
专栏目录
EF 与 sql server 转到mysql
歇息的专栏
03-15 1637
首先说明一下项目的环境，由于考虑到性能问题，或者是CTO的想法，需要将数据库从mssqlserver迁移到mysql，然后就是一顿改。 第一步肯定是要配置服务器环境，从官网上下载了mysql 5.7, 一键配置，设置端口什么的，然后配置远程访问。 第二步就是在vs里面添加mysql的数据源，方便添加EF，然后下载了Mysql for Visual Studio 1.1.1，不知道是1.1.
There is already an open DataReader associated with this Connection which must be closed first
尼奥
03-19 4583
使用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()
There is already an open DataReader associated with this Connection which must be closed first.问题记录
世界既不黑也不白，而是一道精致的灰。
10-14 422
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
MySqlException (0x80004005): 多线程中（There is already an open DataReader associated with this ）错误解决方案
最新发布
martian665的专栏
08-26 924
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#多线程数据库操作。
使用ef core时提示There is already an open DataReader associated with this Connection which must be closed
你要明白，任何问题都不是孤立存在的，一定有人曾经遇到过，并且已经有更好的解决办法了，只是我还不知道。我不应该在黑暗中独自前行，去重新发明轮子，也许我的顿悟，只是别人的基本功！我应该要站在巨人的肩膀上，学习更成熟的经验和方法，然后再来解决这个问题
11-27 2127
使用ef core时提示There is already an open DataReader associated with this Connection which must be closed
[已解决]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 Command which must be closed first
05-31
dataReader.IsClosed) { dataReader.Close(); } ``` 另外，你也可以使用CommandBehavior.CloseConnection选项，在执行完命令之后自动关闭DataReader对象和关联的Connection对象，例如： ``` using (SqlConnection...
fail: 2023/7/14 14:31:33.417 CoreEventId.QueryIterationFailed[10100] (Microsoft.EntityFrameworkCore.Query) An exception occurred while iterating over the results of a query for context type 'iMES.Core.EFDbContext.SysDbContext'. System.InvalidOperationException: There is already an open DataReader associated with this Connection which must be closed first. at Microsoft.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at Microsoft.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) at Microsoft.Data.SqlClient.SqlCommand.ValidateCommand(Boolean isAsync, String method) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.<>c.<MoveNext>b__21_0(DbContext _, Enumerator enumerator) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
07-15
根据您提供的信息，出现了一个异常，提示已经有一个与该连接关联的打开的 DataReader，必须先关闭它。 这个问题通常是由于在使用 Entity Framework 进行查询时，存在未关闭的 DataReader 导致的。DataReaders 是...
C#创建第一个简单登录程序
qq_51025538的博客
12-13 527
首先在依赖项右键，管理NuGet程序包里下载MySQL.Data； 安装完成后就可以使用Mysql； using MySql.Data.MySqlClient; 放代码： using System.Data; using MySql.Data.MySqlClient; namespace ConnectSqlTest { class Program { static void Main(String[] args) { ..
C#连接Mysql之There is already an open DataReader associated with this Connection which must be closed
m0_59051864的博客
11-01 934
C#连接MySql数据库之报错:There is already an open DataReader associated with this Connection which must be closed first
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.即已有打...
EF "There is already an open DataReader associated with this Command which must be closed first."
weixin_33895516的博客
01-19 5286
1.出现问题 场景1：在插入数据之前，先进行判断是否存在 执行SqlDataReader.Read之后，如果还想用另一个SqlCommand执行Insert或者Update操作的话， 会得到一个错误提示：There is already an open DataReader associated with this Command which must ...
Asp.net Core :Already an open DataReader associated with this Connection which must be closed
荒野
01-19 596
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..
Improve_life的博客
12-10 1431
C#数据库操作错误：There is already an open DataReader associated with this Connection which must be closed.. 在进行数据库存储时，遇到错误：“MySql.Data.MySqlClient.MySqlException”类型的异常在 MySql.Data.dll 中发生，但未在用户代码中进行处理。 其他信息: There is already an open DataReader associated wi...
EF There is already an open DataReader associated with this Command
weixin_30698527的博客
09-05 811
捕捉到 System.InvalidOperationException _HResult=-2146233079 _message=意外的连接状态。在使用包装提供程序时，请确保在已包装的 DbConnection 上实现 StateChange 事件。 HResult=-2146233079 解决参考： https://stackoverflow.com/questions/48...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值