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 many major types of connection objects in ADO.NET?

1025

---

can we create synonymn in ms access,sql server,my sql if so explain me with example

2078

---

How do you merge 2 datasets into the third dataset in a simple manner?

990

---

Explain the different row versions available in table?

1050

---

What is the difference between Data adaptor and Data set?

1034

---

How to Read, Add, Update and Delete record in Entity Framework ?

1033

---

What is the difference between OLEDB Provider and SqlClient?

981

---

What are two important objects of ADO.Net?

1013

---

Define the data provider classes that is supported by ado.net?

972

---

What are the different ado.net namespaces are available in .net?

1004

---

What is the difference between the clone() and copy() methods of the dataset class?

1082

---

Define isolation?

956

---

What is difference between datareader and dataadapter?

1043

---

What is ado or jdbc?

924

---

how can implement dropdownlist in particular of dataset when try to update?

2774

---