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 ...

Get Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition 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.