.Net > Input > Intermediate Next/Skip this question

You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?

1. Ensure that the Close method is called on each connection object after it has finished executing.
2. Ensure that each connection object is left open after it has finished executing.
3. Increase the Max Pool Size value inside the connection string.
4. Increase the Min Pool Size value inside the connection string.
5. Increase the Connection Lifetime value inside the connection string.
6. Increase the value of the ConnectionTimeout property of the SqlConnection object.
Answers :
social share share on facebook share on twitter share on google plus share on linkedin
Add Comments :

Login

Register

Next Question