How to enable MultipleActiveResultSets

By FoxLearn 11/9/2024 2:40:53 PM   102
To enable Multiple Active Result Sets (MARS) in SQL Server, you need to modify the connection string of your application.

Add MultipleActiveResultSets=True to your connection string

You can change your web.config, the connection string like this:

<add name="cn" connectionString="Data Source=PC\SQLEXPRESS;Initial Catalog=myDb;Integrated Security=True;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />

This will allow multiple queries to be executed and their results processed concurrently on the same connection.