O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Q&A

Q1:Q How will I know if connection pooling is being used?
A1: Remember, connection pooling is the default (pooling = "true")! You will have to specifically disable this setting if you don't want to use it. In addition, you can always flip on the Performance Monitor for your process (as we did for 17conpool) and see the connection pool's usage.
Q2:Which security model should you use with connection pooling?
A2: Windows authentication should be your default security model approach. It is much more oriented to allowing you to construct and use general connection strings that will be easily matched in the connection pool entries.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required