Connection Pooling in ADO.NET Applications

View PDF

Introduction

Connecting to a database is the single slowest operation inside a data-centric application. Efficiently managing connections through connection pooling is important to application performance. ADO.NET connection pooling allows the reuse of connections rather than the creation of new ones every time the data provider needs to establish a connection to the underlying database.

For most ADO.NET data providers controlling connection pooling behavior is achieved by using connection string options. With DataDirect Connect for .NET it is possible to define and increase the number of connection pools, the number of connections in a pool and the lifetime of pooled connections used by each process.

Connection pooling in ADO.NET is not provided by the core components of the .NET framework. It must be implemented in the .NET data provider itself. All DataDirect .NET data providers offer this improved level of connection pooling functionality. By thoughtfully handling connection management before implementation, you can improve application performance and maintainability.

DataDirect Connect for .NET is the industry's only suite of ADO.NET data providers with a 100% managed architecture, eliminating the need for database clients, boosting performance and delivering a flexible, secure connection to Oracle, DB2, Microsoft SQL Server, and Sybase.

ADO.NET Connection Pooling Topics: (Click to view topic.)

• - Creating a Connection Pool
• - Using Integrated Windows (NTLM) Authentication with SQL Server
• - Adding Connections to a Pool
• - Removing Connections from a Pool
• - Handling Dead Connections in a Pool
• - Handling Distributed Transactions
• - Tips on Opening and Closing Connections
• - Tracking Connection Pool Performance
• - Improve Performance and Efficiency of ADO.NET Applications

Ready to try DataDirect Connect for ADO.NET?
	|	Learn More