How to enable MultipleActiveResultSets
By Tan Lee Published on Nov 09, 2024 359
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.
- SqlException: Cannot insert explicit value for identity column
- How to use decimal precision and scale in EF Code First
- How to add a computed column in EF Core
- Applying Migrations Programmatically in EF Core
- Creating a Database and Table in EF Core
- Database Schema Modifications in EF Core
- Adding a Computed Column in EF Core
- Inheritance Mapping in EF Core
Categories
Popular Posts
11 Things You Didn't Know About Cloudflare
Dec 19, 2024
K-WD Tailwind CSS Admin Dashboard Template
Nov 17, 2024
Responsive Animated Login Form
Nov 11, 2024
Responsive Admin Dashboard Template
Nov 11, 2024