How to enable MultipleActiveResultSets
By FoxLearn 11/9/2024 2:40:53 PM 102
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.
- Resolving the "Command 'dotnet ef' Not Found" Issue When Creating Migrations
- How to use decimal precision and scale in EF Code First
- Dapper vs Entity framework
- How to solve 'DbContextOptionsBuilder' does not contain a definition for 'UseSqlServer' in .NET Core
- How to use Identity column in EF7
- How to insert master/details data in EF Code First
- Connection String in Entity Framework 6
- How to use stored procedure in Entity Framework Core
Categories
Popular Posts
11 Things You Didn't Know About Cloudflare
12/19/2024