Answer Posted / babina

The old ADO (ActiveX Data Object) has evolved to ADO.NET in
the .NET Framework. The ADO.NET object is a lightweight
object. The ADO Recordset was a huge object in ADO. It
provided the ability to support multiple types of cursors.
It provided fast lightweight "firehose" cursor and also
supported a disconnected client-side cursor that supported
tracking, optimistic locking, and automatic batch updates of
a central database. However, all of this functionality was
difficult to customize.
ADO.NET breaks the functionality of the ADO object to
multiple classes, thereby allowing a focused approach to
developing code. The ADO.NET DataReader is equivalent to the
"firehose" cursor. The DataSet is a disconnected cache with
tracking and control binding functionality. The DataAdapter
provides the ability to completely customize how the central
data store is updated with the changes to a DataSet.

What is the difference between OLEDB Provider and SqlClient?

970

---

What is connection pooling and what is the maximum pool size in ado.net connection string?

935

---

Explain the namespaces in which .net has the data functionality class.

1060

---

What are the advantages of ado.net?

898

---

Is datareader faster than datatable?

942

---

What is the maximum pool size in ado.net connection string?

926

---

What are disadvantages of microsoft-provided data provider classes in ado.net?

1016

---

Which parameter of ConnectionString is used to specify the name of the database?

1028

---

How does entity framework work?

900

---

What is read only and forward only in ado.net?

926

---

What is the difference between ado.net and entity framework?

1034

---

Can we connect two dataadapters to same data source using single connection at same time?

961

---

What are the objects of ado.net?

1053

---

What is maximum pool size in ado.net connection string?

957

---

What is the difference between sqlcommand and sqldataadapter?

977

---