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's singlecall activation mode used for in .net?

537


Compare & contrast rich client (smart clients or windows-based) & browser-based web application

530


Tell us what is a sealed class?

540


What is a windows process in .net?

568


What are the main components in .net?

517






Can you explain what do you understand about web service?

595


What is a design pattern and what is it for?

543


Explain the garbage collection process?

626


How is .net able to support multiple languages?

601


Which namespace is used to support multithearding in .NET?

514


Explain what is the difference between web application and enterprise application?

536


What is .net core used for?

531


Please explain what are an inheritance, polymorphism, and encapsulation?

565


What is the root class in .net?

647


Elements of CAS

1738