Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 66478 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / sridhar.m
Data reader
1. It is a read only and forward only data.
2. U can access one table at time.
3. It can't persist the data.
4. It is comes under connected architecture.
5. One of the most advantage is it is much faster than data
adapter
6.datareader connection oriented.
Data set:
1. It is defined with multiple tables.
2. It can persist the data.
3. It is a relational data cache hosted in application
domain during execution.
4. It is a disconnected architecture.
5. It can't defined with out data adapter.
6.whereas dataset disconnected.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
Define data adapter?
What is the role of data provider in ado.net?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
What is the difference between linq and ado.net?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
Define Execute Reader?
Is bulk insert faster than insert?
What is the return type of executescalar?
What is microsoft ado?
Explain the two fundamental objects in ado.net?
What you mean by filtering of data?
What is ado code?
Which object is used to add relationship between two Datatables?
