Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 68239 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / sudheendra
DataReader
Datareader is like a forward only recordset. It fetches one
row at a time so very less Network Cost compare to
DataSet(Fetches all the rows at a time). DataReader is
readonly so we cannot do any transaction on them. DataReader
will be the best choice where we need to show the data to
the user which requires no transaction ie reports. Due to
DataReader is forward only we cannot fetch the data
randomly. .NET Dataproviders optimizes the datareaders to
handle the huge amount of data.
DataSet
DataSet is always a bulky object that requires lot of memory
space compare to DataReader. We can say the dataset as a
small database coz it stores the schema and data in the
application memory area. DataSet fetches all data from the
datasource at a time to its memory area. So we can traverse
through the object to get required data like qureying database.
The dataset maintains the relationships among the datatables
inside
it. We can manipulate the realational data as XML using
dataset.We can do transactions (insert/update/delete) on
them and finally the modifications can be updated to the
actual database. This provides impressive flexibility to the
application but with the cost of memory space. DataSet
maintains the original data and the modified data seperately
which requires more memory space. If the amount of data in
the dataset is huge
then it will reduce the applications performance dramatically.
The following points will improve the performane of a dataset...
1. Don't use the commandbuilder to generate the sql statements.
Though it reduces the development time the query generated
by the command builder will not be always as required. For
example
To update the details of an author table the command
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Give an example that shows how to execute a stored procedure in ado.net?
What are all features of ADO.Net?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
How to check if a datareader is closed or opened? IsClosed()
What are the different methods available under the sqlcommand class to access the data?
Is bulk insert faster than insert?
Define data adapter?
What is ado full form?
What are the Features of a dataset
Describe ado.net object model in detail.
describe the dataset object in ado.net.
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What are the 3 major types of connection objects in ado.net?
What are the rules to implement connection pooling?
What is sql connection in ado.net?
