Where to find a good database (factory) class with connectionpooling?

Question

I found a lot of information about how to make a database factory or how to deal with connection pooling but i nowhere found a complete solution.

I have always used my own solutions, but they're not complete i think or could be improved.

Are there some good designed classes any of you use that i can find on the net?

Thanks ;-)

Answer 1

I think probably the best example of this would be the DatabaseFactory class that is found within Microsoft's own Enterprise Library.

It's available from the Codeplex site and comes with full source code. The downside is that the code is in C# rather than VB.NET. It does, however, offer a DatabaseFactory class (amongst others) that represent best practise approaches to these programming areas.

Bear in mind that the Enterprise Library will use System.Data namespace classes and so can take advantage of any "built-in" connection pooling available (for example when connecting to SQL Server and using the same connection string).