How to enable MultipleActiveResultSets
By Tan Lee Published on Nov 09, 2024 387
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
Freedash bootstrap lite
Nov 13, 2024
Elegant Bootstrap 5 HTML5 Admin Dashboard Template
Nov 17, 2024
Gentella Admin Template
Nov 14, 2024