How to enable MultipleActiveResultSets
By FoxLearn 11/9/2024 2:40:53 PM 295
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
11/13/2024
Regal Admin Dashboard Template
11/18/2024
Motiv MUI React Admin Dashboard Template
11/19/2024