Answer Posted / prakash tiwari

Data Reader will read only one record at a time.So memory
consumption will be less,it is purely connection oriented
it will use connection exclusively when datareader is
closed.the memory will be released on the server machine
and connection will be used for any other purpose.

Data Adapter acts as a mediator between dataset and
database server.
it will read data from the database server and places with
in dataset
the manipulations on the dataset will be updated with the
database server

How can I retrieve two tables of data at a time by using data reader?

1080

---

What is defaultview in datatable?

1069

---

What is difference between datatable and dataset?

1122

---

Explain the difference between ado and ado.net?

991

---

What Is Difference Between Ado And Ado.net?

1073

---

Define atomicity?

1085

---

Define connection string?

1126

---

Describe briefly an ADO.NET Dataset ?

1168

---

Explian About DataAdapters

1079

---

Explain what are the steps to connect to a database?

1014

---

What is an ado?

1027

---

What is Serialization in .NET? what are the types of Serialization?

1121

---

What is ado.net connection?

1019

---

What are the advantages of ado.net?

953

---

What are the differences between OLEDB and SQLClient Providers?

1237

---