通常出现在嵌套查询数据库(比如在一个qry的遍历时,又进行了数据库查询)
通过在连接字符串中允许MARS可以轻松解决这个问题。 将MultipleActiveResultSets = true添加到连接字符串的提供程序部分
"SqlServerConnection": "Server=.\\sqlexpress;Database=test;Integrated Security=True;Connect Timeout=15;MultipleActiveResultSets=true",
相关文章
- 12-24There is already an open datareader associated with this command
- 12-24There is already an open DataReader associated with this Command which must be closed first
- 12-24关于MultipleActiveResultSets属性导致的There is already an open DataReader associated with this Command which must be closed first的解决方法
- 12-24There is already an open DataReader associated with this Connection which must be closed first
- 12-24在实体对象中访问导航属性里的属性值出现异常“There is already an open DataReader associated with this Command which must be closed first”