Know-how can be used to supplement the ~sqlserver connection of the multiplexing Multipleactiveresultsets

Back to Catalog

multipleactiveresultsets can make the database connection reusable, but when you're on the Moebius cluster tool, this option doesn't turn on (false by default), and when you use an ORM tool like EF, This option will be added by default, it is to improve the performance of the program, the advantage is that the database connection resources are exhausted, the use of the method is simple, only need to add it to the data connection string.

For example: server= (local); Integrated Security = True;database=test; Multipleactiveresultsets=true;

In the test we released, after adding Multipleactiveresultsets, the number of connections to the same process remains at 1, that is, you open several more of the same program, it is in the SQL sp_who view is also one.

Back to Catalog

Know-how can be used to supplement the ~sqlserver connection of the multiplexing Multipleactiveresultsets