Hi Dorris,
Not the exact answer to your question. Take a look at object-relational mapping (ORM) software -- examples: LINQ to SQL, Entity Framework, LLBLGen Pro, Telerik OpenAccess. The latter I can recommend as a very decent one.
The ORM software hides many database-related complexities from developer. With ORM you do not deal with connections, databases, tables, views and stored procedures directly, but through a set of classes. Not without its own issues & difficulties, the ORM still a great way of handling data.
Major ORMs can handle connections and connection pools -- that's an answer to your question.