Explain about Connection Pooling? Connection pooling is a concept which deals with database connection. A Connection Pool maintain last database connection active state when connection is ideal. Whenever you want to make a transaction with database once again you have to open connection when it is ideal, instead of that connection pooling will maintain open and reusable connections. A Connection Pool is released from the buffer or memory when the last connection to the database is closed. By default Connection Pooling turned on in ado.net; whenever you want to change it off, you have to specify Pooling = false in the connection string . We can specify limit to connection pooling by default the maximum limit is 100. You will specify in connection string. It will improves the performance and scalability of the application It is managed by a program in ado.net that we called as Pool Manager. This program will ma...
This site is made for freshers to guide by which they can get great information faqs dotnet csharp,sqlserver