Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Dataset and DataReader?
Can dataReader hold data from multiple tables?
- 3 Answers
- 9227 Views
- Fulcrum Logic, Merrill Lynch, I also Faced
- E-Mail Answers
Answer Posted / naresh
Data reader:
1. It is a read only and forward only data access to data.
2. You 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 can access multiple tables at a time.
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 define with out data adapter.
Yes.dataReader hold data from multiple tables. The SELECT
statement may have columns that belong to one or more
"tables in the database". By example using a JOIN
or something similar.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is ado.net architecture?
What is data view and variable view?
What is the hierarchy of data in databases?
Explain how to find the given query is optimised one or not?
How to work with disconnected data - the dataset and sqldataadapter?
How do you merge 2 datasets into the third dataset in a simple manner?
Which method is used by command class to execute SQL statements that return single value?
Explain how to create dynamic gridview?
What is the difference between ado.net and oledb?
Which is faster ado.net or linq?
What is the use of sqldatareader class?
What do you know about ado.net's objects?
Explain what are acid properties?
What is difference between executenonquery and executequery?
What do you know about ADO.NET's objects and methods?
