Answer Posted / gyany

Connection Pooling:-
Connection pooling reduces the number of times that new
connections need to be opened. The pooler maintains
ownership of the physical connection. It manages
connections by keeping alive a set of active connections
for each given connection configuration. Whenever a user
calls Open on a connection, the pooler looks to see if
there is an available connection in the pool. If a pooled
connection is available, it returns it to the caller
instead of opening a new connection. When the application
calls Close on the connection, the pooler returns it to the
pooled set of active connections instead of actually
closing it. Once the connection is returned to the pool, it
is ready to be reused on the next Open call.

Explain the difference between data reader and data adapter?

910

---

How to maintain the relation between two tables in ADO.NET?

954

---

Explain advantages of ado.net?

1000

---

Explain sqlconnection object?

935

---

Explain the advantage of ADO.Net?

941

---

Is ado.net dead?

956

---

What is the difference between Optimistic and Pessimistic locking?

927

---

Explain the difference in record set and dataset?

878

---

What is difference between executenonquery and executequery?

907

---

How to creating a SqlCommand Object?

1072

---

Define executenonquery?

867

---

How to identify the updated rows in a dataset?

976

---

What are the ado.net connection pooling parameters?

907

---

How can we add/remove row's in "datatable" object of "dataset"?

971

---

What is acid in ado.net?

953

---