Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between DataReader and DataAdapter / DataSet and
DataAdapter?
- 3 Answers
- 32962 Views
- TCS, I also Faced
- E-Mail Answers
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 are the ado.net connection pooling parameters?
What does executereader return?
What is row state?
What is Serialization in .NET? what are the types of Serialization?
Describe connection object in ado.net
What is a sqldataadapter?
What are the data access namespaces in .NET?
What is the difference in record set and dataset?
What is difference between entity framework and ado.net?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is difference between dataset and datatable?
What is Dataset Object?
What is linq and entity framework?
How to pass multiple tables in datasets simultaneously?
What is aggregate root?
