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.
- 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
Horizon MUI Admin Dashboard Template
Nov 18, 2024
Elegent Material UI React Admin Dashboard Template
Nov 19, 2024
Dash UI HTML5 Admin Dashboard Template
Nov 18, 2024
Material Lite Admin Template
Nov 14, 2024