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
How do you update database through dataset?
Describe briefly an ADO.NET Dataset ?
Can we do database operations without using any of the ado.net objects?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
Which control of the BindingNavigator returns the current position within the data source?
What are the ado.net components?
What is partial class?
Which database is the ado.net sql connection object designed for?
How do you update a dataset in ado.net?
Which is better entity framework or ado.net?
Define isolation?
What is oledb connection?
What is aggregate root?
What are the different execute methods of Ado.Net?
What is an orm, and why would you use one instead of plain old ado.net?