How to enable MultipleActiveResultSets
By FoxLearn 11/9/2024 2:40:53 PM 248
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.
- How to disable the SameSite Cookies policy in Cefsharp
- How to fix 'CEF can only be initialized once per process'
- How to use decimal precision and scale in EF Code First
- EF Core - Adding a Foreign Key
- EF Core - Inheritance Mapping
- EF Core - Applying Migrations Programmatically
- EF Core - Creating a Database and Table
- EF Core - Database Schema Modifications
Categories
Popular Posts
Stisla Admin Dashboard Template
11/18/2024
Admin Tailwind CSS Admin Dashboard Template
11/18/2024
Portal HTML Bootstrap
11/14/2024