- Database Connection - Datereader requires an open database connection whereas Dataset does not require an open database connection
- Namespace - Datereader belongs to System.Data.SqlClient or System.Data.OleDB whereas Dataset belongs to System.Data
- Record Set - Datereader is forward only and read only whereas Dataset is not forward only and read only
- Data Source - Datereader can get data from managed data provider. Data cannot be loaded manually whereas Dataset can get data from managed data provider .Data can be loaded manually by XML etc.
- Performance - DataReader has faster retrival and better performance then Dataset
What is difference between Dataset and DataReader ?
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Answer : WCF belongs to System.ServiceModel
-
Different types of assemblies are : Static and Dynamic assemblies Private and Shared assemblies Single file and Multiple file assemblies ...
-
Authorization is used to determine whether user has access to resource or not. There are two ways to authorize a resource : File authoriza...
-
Operation behaviour are scoped at Operation level. It is used for transaction flow , serialization , parameter handling.
-
Different type of method parameters in C# are : Value Parameter Reference Parameter Output Parameter
-
Abstract class has following features : cannot be instantiated contain abstact methods and properties cannot modify abstract class with s...
-
OOPs concepts that C# supports are : Abstraction : is a process that involves identifying the crucial behavior of an object and eliminatin...
-
Characteristics of well designed normalized database are : Table should have identifier Table should store data for single type of entity...
-
There are five types of contracts : Service Contract Operation Contract Data Contract Message Contract Fault Contract Please refer be...
Posts
No comments:
Post a Comment