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

Summary

In this hour, you've seen how connection pools are orchestrated and that they are embedded in the individual .NET data providers themselves. This maximizes the strengths and individual characteristics of each data provider's implementation. In addition, you have learned about the connection keywords that are directly related to connection pooling and control its behavior. Because connection pooling is such a critical aspect of large applications and scalability, it is always a good idea to monitor how effectively the values you choose are being utilized over time. Adjust these as needed. You can use Performance Monitor to regularly get a good feel for how things are going.

The really good news to this whole story is that Microsoft has ...

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