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.

Get Sams Teach Yourself ADO.NET in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.