我的代码中有以下连接字符串:
SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["RaiseFantasyLeagueConnectionString"].ConnectionString);
我的webconfig如下所示:
<connectionStrings>
<add name="RaiseFantasyLeagueConnectionString" connectionString="Data Source=MATT-PC\SQLEXPRESS;Initial Catalog=Raise;Integrated Security=True" providerName="System.Data.SqlClient"/>
谁能告诉我在哪里可以为我的连接启用MultipleActiveResultSets?
发布于 2013-04-01 02:10:47
这真的很简单,只需添加
MultipleActiveResultSets=true;
因此,在您的web.config中,以这种方式更改连接字符串:
connectionString="Data Source=MATT-PC\SQLEXPRESS;" +
"Initial Catalog=Raise;Integrated Security=True;" +
"MultipleActiveResultSets=true;"
发布于 2013-04-01 02:19:26
试试这段代码
<connectionStrings>
<add name="RaiseFantasyLeagueConnectionString" connectionString="Data Source=MATT-PC\SQLEXPRESS;Initial Catalog=Raise;Integrated Security=True ;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient";/>
必须引用此Msdn article
https://stackoverflow.com/questions/15732642
复制相似问题