Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 68200 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
How to Read, Add, Update and Delete record in Entity Framework ?
What are the disadvantages of using datalist?
What is the difference between DataReader and DataSet in ADO.NET?
What are good ado.net object to replace to ado recordset object.
What does sqldatareader return?
What is ambient transaction?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
How can we check that some changes have been made to dataset since it was loaded?
Explain the difference in an abstract class and an interface?
What is the difference between oledb sql server and oledbdotnet provider?
Explain the differences between oledb sql server, oledbdotnet provider?
Describe datareader object of ado.net with example.
What is the difference between Command and CommandBuilder object?
How to pass values into a datatable?
What is the namespaces being used to access oracle database?
