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
- 9182 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
Define the executescalar method?
How would you connect to a database by using .NET?
Describe the command object and its method.
What are all the classes that are available in System.Data Namespace?
How to bind the controls(best practice) comboboxes to the data in the dataset?
How to identify the updated rows in a dataset?
Explain the advantages and disadvantages of using datalist?
How to store data in memory?
Does ado.net use odbc?
What is ole db and odbc?
What is the namespaces being used to access oracle database?
What are the advantages of oledb compared with other classes?
What are the benefits of using ado.net?
What are the advantage of ado.net?
What do you mean by ‘batch updates’?
