Answer / Kushal Sharda

The rules to implement connection pooling in ADO.NET are:
1. Connection Pooling must be enabled by setting the ConnectionString property of a connection object.
2. The minimum and maximum number of connections that can be maintained by the pool should be defined using the MinPoolSize and MaxPoolSize properties respectively.
3. The time-out value for idle connections can be set using the Connect Timeout property.
4. It's essential to release connections back to the pool after use using the Close() method.
5. To avoid connection exhaustion, it's advisable to open and close connections only when necessary.

What is sql command in ado net?

1 Answers  

---

how to keep track of index in listbox items.

2 Answers  

---

Difference between OLEDB Provider and SqlClient ?

2 Answers  

---

What are the data access namespaces in .NET?

1 Answers  

---

what is different between SqlCommand object and Command Behaviour Object

3 Answers  

---

What is variable view?

1 Answers  

---

Why do we need ado.net?

1 Answers  

---

what is the syntax code for oldb to connect oracle

3 Answers   IBM,

---

what are the two key events for the sql connection class? explain the differnce between the two.

2 Answers   HCL, NIIT, Zensar,

---

what is a dataset?

9 Answers   Choice Solutions,

---

What is the difference between Response.Expires and Reponse.ExpiresAbsolute?

1 Answers  

---

Differnces between oracle 9i and sql server?

2 Answers   College School Exams Tests, Microsoft,

---