What is the difference between Dataset and DataReader? Can
u breif me ADO.net classes and architecture

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is manifest in .net?

618


Usually in .net, the clr takes care of memory management. Is there any need for a programmer to explicitly release memory and resources? If yes, why and how?

581


How to spawn a thread?

587


What's wrong with a line like this? Datetime.parse(mystring);

574


What is the advantage of packaging over xcopy in .net?

600






What is lambda expressions in c#?

613


What are the new thee features of com+ services, which are not there in com (mts)?

524


Which namespace does it belong to by default?

581


Explain how com+ related to the dna architecture?

572


What is machine.config in .net?

584


What is 3 tier architecture?

587


What is the use of UML in .Net

623


Explain what do the terms “boxing” and “unboxing” mean?

585


How will you make .NET programs work in Linux ?

1496


Conceptually, what is the difference between early-binding and late-binding?

596