How to enable MultipleActiveResultSets
By FoxLearn 11/9/2024 2:40:53 PM 36
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 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
- How to use decimal precision and scale in EF Code First
- How to enable webRTC in CefSharp in C#
- How to fix 'CEF can only be initialized once per process'
Categories
Popular Posts
Spica Admin Dashboard Template
11/18/2024
