How to enable MultipleActiveResultSets

By Tan Lee Published on Nov 09, 2024  321
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.