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

What is the return type of executescalar?

1019

---

What are the drawbacks of using ado.net?

980

---

What providers does Ado.net uses?

1022

---

If we are not returning any records from the database, which method is to be used?

1331

---

Is bulk insert faster than insert?

923

---

What is a dataview?

977

---

What are all the different methods under sqlcommand?

990

---

What are the major difference between classic ADO and ADO.NET?

1013

---

Which is faster sqldataadapter and sqldatareader?

931

---

How to retrieve the user id which is provided while windows authentication?

1099

---

Describe the disconnected architecture of ADO.NET’s data access model.

1063

---

Explain the difference between ado and ado.net?

942

---

What is the difference between Dataset. clone and Dataset.copy?

1050

---

What is dataadapter in ado.net?

924

---

How do you update a dataset in ado.net and how do you update database through dataset?

928

---