|
INTERVIEW QUESTIONS
MICROSOFT
ADO.NET
DETAILS
Question: How to select data set or data reader?
Answer: The data reader is more useful when you need to work with large number of tables, database in non-uniform pattern and you need not execute the large no. of queries on few particular table. When you need to work on fewer no. of tables and most of the time you need to execute queries on these fewer tables, you should go for the dataset.
It also depends on the nature of application. If multiple users are using the database and the database needs to be updated every time, you must not use the dataset. For this, .Net provides the connection oriented architecture. But in the scenarios where instant update of database is not required, dataset provides optimal performance by making the changes locally and connecting to database later to update a whole batch of data. This also reduces the network bandwidth if the database is accessed through network.
Disconnected data access is suited most to read only services. On the down side, disconnected data access architecture is not designed to be used in the networked environment where multiple users are updating data simultaneously and each of them needs to be aware of current state of database at any time (e.g., Airline Reservation System).
|
|
|
Category |
ADO.NET Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7039 users |
Added on |
8/31/2014 |
Views |
71892 |
Rate it! |
|
|
Question:
How to select data set or data reader?
Answer:
The data reader is more useful when you need to work with large number of tables, database in non-uniform pattern and you need not execute the large no. of queries on few particular table. When you need to work on fewer no. of tables and most of the time you need to execute queries on these fewer tables, you should go for the dataset.
It also depends on the nature of application. If multiple users are using the database and the database needs to be updated every time, you must not use the dataset. For this, .Net provides the connection oriented architecture. But in the scenarios where instant update of database is not required, dataset provides optimal performance by making the changes locally and connecting to database later to update a whole batch of data. This also reduces the network bandwidth if the database is accessed through network.
Disconnected data access is suited most to read only services. On the down side, disconnected data access architecture is not designed to be used in the networked environment where multiple users are updating data simultaneously and each of them needs to be aware of current state of database at any time (e.g., Airline Reservation System). Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What are the performance considerations when using dataset?
|
View Answer
|
|
What's the difference between accessing data with dataset or data reader?
|
View Answer
|
|
What does it mean by connected data access architecture of ADO.Net?
|
View Answer
|
|
What does it mean by disconnected data access architecture of ADO.Net?
|
View Answer
|
|
What is ADO.Net?
|
View Answer
|
|
How do you get records number from 5 to 15 in a dataset of 100 records? Write code.
|
View Answer
|
|
How do you declare a static variable and what is its lifetime? Give an example.
|
View Answer
|
|
On order to get assembly info which namespace we should import?
|
View Answer
|
|
What are good ADO.NET object(s) to replace the ADO Recordset object?
|
View Answer
|
|
What is the difference between ADO and ADO.NET?
|
View Answer
|
|
How to copy the contents from one table to another table and how to delete the source table in ado.net?
|
View Answer
|
|
What is the difference between data reader and data adapter.
|
View Answer
|
|
How to copy the contents from one table to another table and how to delete the source table in ado.net?
|
View Answer
|
|
How to find the given query is optimised one or not?
|
View Answer
|
|
What is the execution procedure in oracle ?
|
View Answer
|
|
Can we connect two datareader to same data source using single connection at same time?
|
View Answer
|
|
Why can't we use Multiple inheritance and garbage collector paralelly in .net
|
View Answer
|
|
How many records can take clustured index in sql server
|
View Answer
|
|
Difference between SqlCommand and SqlCommandBuilder
|
View Answer
|
|
Why edit is not possible in repeater??
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All ADO.NET Interview Questions & Answers - Exam Mode /
Learning Mode
|