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
- 6440 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
What is garbage collection and how it works ?
Explain how to manage pagination in a page using .net?
What does il do?
What are the purposes of using .net?
What is a web service in .net?
Define satelite assembly?
Please explain when should you use .net web forms over asp.net mvc?
which method do you use to redirect the user to another page without performing a round trip to the client? How?
What class does icon derive from? Isn't it just a bitmap with a wrapper name around it?
How does u handle this COM components developed in other programming languages in .NET?
What is class library in .net
Please explain is the jit an interpreter?
What is reflection and what is it for?
What is Event Bubbling in .NET?
object is physical and class is logical..here class is not occupying any memory as our definition of class but i got a question then the class where it stores if it is not occupying any memory....
