- 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
-
Cache Callback provides an ability where by some actions can be performed when that item is removed from cache CacheItemRemovedCallback ex...
-
XML DOM loads the entire xml document into memory whereas Simple API for XML ( SAX ) does not load entire xml document into memory XML DOM ...
-
Different types of diagrams in UML : UseCase diagram Class diagram Object diagram State diagram Sequence diagram Collaboration diagram...
-
Virtual-Override and New Class Child inherits from Class Parent and has mehtod ShowVirtualOverride() and ShowNew() methods. Please see th...
-
Question : Name few C# 3.0 enhancements ? Answer : The C# 3.0 language enhancements are as follows: Implicitly typed local variables I...
-
If locaction attribute is specified, must be one of: Any, Client, Downstream, None, Server or ServerAndClient.
Posts
No comments:
Post a Comment