问题描述
我得到的是已经有一个与此命令相关联的打开的DataReader，必须先关闭它."将我们的应用程序部署到Azure时出现错误，但是在本地运行良好.我的连接字符串上具有MultipleActiveResultSets = true.请
I'm getting a "There is already an open DataReader associated with this Command which must be closed first." error when deploying our application to Azure, but, works fine locally. I have MultipleActiveResultSets=true on my connection string. Please advise.
推荐答案
I了解您具有'MultipleActiveResultSets = true ' 在您的连接字符串中. 如果您使用的是Visual Studio，请查看配置-导航到发布网站">在设置"标签中> 显式添加MultipleActiveResultSets = true并选中框在运行时使用此连接字符串(更新目标web.config)，看看是否有帮助.
尝试重新下载发布配置文件，看看是否有任何区别.
I understand you have ‘MultipleActiveResultSets=true’ in your connection string. If you are using Visual Studio, kindly review the configuration – Navigate to Publish Web> In the Settings tab> Add MultipleActiveResultSets=true explicitly and check the box –‘Use this connection string at runtime (update destination web.config) and see if that helps.
Try re-downloading the publishing profile and see if that makes any difference.
此外，您还可以尝试 建议 部署 VS运行时问题 到 进一步隔离问题.
Additionally, you could try the suggestions outlined in the GitHub wiki page Deployment vs runtime issues to isolate the issue further.
这篇关于得到“已经存在与该命令相关联的打开的DataReader，必须首先关闭它".错误.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！