Difference between datareader and dataset?
Answer Posted / chaitanya k
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
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.
| Is This Answer Correct ? | 121 Yes | 12 No |
Post New Answer View All Answers
What are the Data providers in ADO.Net?
What is different between sqlcommand object and command behavior object?
How to create data relations?
What does ado stand for in ado.net?
What is ado rdo dao in visual basic?
What is a control toolbox?
What are the advantages and disadvantages of using datalist?
What is fill method in ado.net?
Which is faster sqldataadapter and sqldatareader?
Explain the difference between ado and ado.net?
Can we do database operations without using any of the ado.net objects?
Explain the different row versions available in table?
What is an ADO.Net?
Do you use stored procedure in ado.net?
What is executenonquery ado.net?