O'Reilly logo

Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition by David Sceppa

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

Connection Pooling

Like Microsoft’s previous data access technology, ADO.NET includes built-in support for connection pooling.

Connection Handles and Physical Connections

If you’re working with Visual Studio, you can examine some of the internal private properties of objects using the Visual Studio debugging tools. For example, write some code to open a SqlConnection and set a breakpoint on the call to the Open method. Add the object to the Watch window by right-clicking the object in your code and selecting Add Watch. In the Watch window, expand the area marked Non-Public Members. Scroll down and you’ll see a private property called InnerConnection.

The contents of the InnerConnection property represent a very thin layer over the physical connection ...

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