StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><em>Update: Multiple Active Result Sets (MARS) can now be enabled for the injected connection string by using the Sequelizer admin panel. This is the recommended approach since the <code>web.config</code> no longer needs to be modified, which causes an <code>AppDomain</code> reload during startup</em></p> <p>I came up against this today! I did the following:</p> <pre><code>var configuration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~"); var connectionString = configuration.ConnectionStrings.ConnectionStrings["ConnStringAlias"].ConnectionString; if (!connectionString.Contains("multipleactiveresultsets=True;")) { connectionString = connectionString.TrimEnd('\''); connectionString = connectionString += "multipleactiveresultsets=True;\'"; configuration.ConnectionStrings.ConnectionStrings["ConnStringAlias"].ConnectionString = connectionString; configuration.Save(); } </code></pre> <p>The <code>MultipleActiveResultSets</code> property must be inside the <code>provider connection string</code>, which is why you received an error regarding the format of your connection string.</p> <p>I seen a few 'solutions' around but none seemed to work for me, including the solution at the bottom of a <a href="http://support.appharbor.com/kb/add-ons/using-sequelizer" rel="nofollow">support page</a> of how to do exactly this on AppHarbor's site. The solution provided even sends the application into an infinite loop as the application will restart every time the <code>web.config</code> file is saved, which is every time in the example.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload