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
Which parameter of ConnectionString is used to specify the name of the database?
Explian About DataAdapters
What is the difference between Dataset. clone and Dataset.copy?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is data adapter in ado.net with example?
What is ado.net connection?
What is a sqldataadapter?
What are the essential features of ado.net?
What is bubbled event can you please explain?
What are the steps you will take to improve performance?
Describe ado.net object model in detail.
What is difference between dataset and datatable?
Does executenonquery return a value?
What is connected architecture in ado.net?
What are the 3 major types of connection objects in ado.net?