Difference between DataReader and DataAdapter / DataSet and
DataAdapter?
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
Is This Answer Correct ? | 52 Yes | 6 No |
Post New Answer View All Answers
What is datatable in ado.net?
What is sqlconnection and sqlcommand?
What is serialization and de-serialization in .net?
How to work with disconnected data - the dataset and sqldataadapter?
What does sqldatareader return?
What is a sqldataadapter?
What is difference between datareader and dataadapter?
How can we add relation between tables in a dataset?
What is openrowset?
How do you find the count of records in a dataset?
What are two types of transaction supported by ado.net?
What are dcl commands?
What are the types of databinding?
Explain the basic use of "dataview" and explain its methods.
What is a column variable?