Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



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

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

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

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

Post New Answer

More Dot Net General Interview Questions

What is a formatter in .net?

0 Answers  


Please explain about "this" object

4 Answers   CTS,


What are the challenging issues you have faced in implementation project/Maintainance project in .net Functionality? How you have overcome that issue?

0 Answers   TCS,


When we use windows api in .net is it managed or unmanaged code?

0 Answers  


How anonymous method is different from a lambda expression?

0 Answers  






What are nullable types in .NET

0 Answers   TryTechnicals Pvt Ltd,


What are the improvements made in cas in .net 4.0?

0 Answers  


How many namespaces are in .net version 1.1?

0 Answers  


How would ASP and ASP.NET apps run at the same time on the same server?

1 Answers  


What is Garbage Collection in .Net and what is the Garbage collection process?

4 Answers  


Explain what is the reason of occurring overflow-underflow arithmetic exception error, it shows error message when we run our program by adding control?

0 Answers  


C++ & C# differences ?

1 Answers  






Categories