What is the difference between Dataset and DataReader? Can
u breif me ADO.net classes and architecture
- 2 Answers
- 5846 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manikanta.srinu
Dataset:1)It is a disconnceted architecture why because
once you fill data in dataset,it'll keep data in it even DB
conncetion was closed.and also no need write code for open
& close database connection.
2)It contain collection of datatables.It can be Add,Edit
and modify at runtime.This property is called Read and
write.
DataReader:
1)It is a Connceted architecture why because we have open
connection to get data from DB.
2)It is Forwarad only.This is only for Reading data from DB.
Diffrence:
==========
DataReader is faster than Dataset,because this is read only.
ADO.net classes
===============
System.data is importent class for ADO.Net.It have
collection of class like Dataset,DataReader.etc...
System.Data.SqlClient;
This is for used making SQL connetion,Command.etc..
Architecture
============
SQLDataProvider is contain DataAdpter.This is used to
retive data from DB and then fill dataset to client.and
also It can do Add,Edit and modify operation on DB.
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / md irshad
1-data set like a container.it's follow the disconnected
architecture while data reader follow connected architecture.
2-data reader provide forward only and read only access to
data while data set object can hold more than one table from
the same data source.
| Is This Answer Correct ? | 1 Yes | 0 No |
I have a problem in installing visual Studio 2008 on PC that have Celeron Processor ? afterAll InstallionFaied . Pls suggest me . Is it possible or not .if Yes then How ?
in hibernate, what is dirty reading?
Can u explain me What is encapsulation?
7 Answers Deloitte, GK companies,
What is common type system (cts)?
What does stateless mean?
What are two different types of remote object creation mode in .net?
Dot Net is Platform Independent or Platform Dependent..?
when web.config file is being called or referenced?tell me about the searialized procedure followed in page loading.
What do the terms “boxing” and “unboxing” mean?
Explain the difference between garbage collections in .net 4.0 and earlier versions?
Please explain is the jit an interpreter?
What is meant by localization?
Dot Net Framework 
