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
- 6704 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
1 mor thing guyz....can i go for C# directly without C++ /JAVA knowledge for dot net ..???
State the differences between the dispose() and finalize().
Which namespace is the base class for .net Class library?
What is model-view -controller Architecture?
Describe difference between inline and code-behind?
Should I use readerwriterlock instead of monitor.enter/exit?
Difference b/w dataset.clone and dataset.copy ?
What is misl?
What is Method Overriding? How to override a function in C#?
i m fresher,hav SQL knowledge but in my ofc. i hav to work on dotnet. so plz tell me how to learn it,? from where to stat? i hav C prog. knowledge, ASP.net
Tell us what is a variable of implicit type and what is its scope?
Value type & data types difference. Example from .NET.
Dot Net Framework 
