Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Dataset and DataReader? Can
u breif me ADO.net classes and architecture
- 2 Answers
- 6580 Views
- Deloitte, I also Faced
- E-Mail Answers
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
A developer company sends dlls to the client. Some client is not happy current functionality, so request some modification. Developer made some changes and send new dll to all clients. Some client is happy with old version, tell me minimal change to so that neither clients get affected?
What is the use of activex control in .net?
What is dot net and its uses?
Explain assemblies in .net?
Explain the difference between garbage collections in .net 4.0 and earlier versions?
what is machine key error in .NET how can we solve it?
How to load the contents of an xml file into an xmldocument object?
Explain what is an interface and what is an abstract class? Please, expand by examples of using both. Explain why?
Can you create instance of a class which has private constructor?
What are the new features in .net core?
What exactly is being serialized when you perform serialization in .net?
What are code contracts?
What is meant by globalization and localization?
Explain the different types of proxy patterns?
Explain difference between panel and groupbox classes using .net?
