8.30.2012

DataReader vs DataSet vs DataAdapter

Difference between DataReader,DataSet and DataAdapter

S.No DataReader DataSet / DataAdapter
1
Database Connecting Mode:
Connected mode
Database Connecting Mode:
Disconnected mode
2
Data Navigation:
Unidirectional i.e., Forward Only
Data Navigation:
Bidirectional i.e., data can navigate back and forth
3
Read / Write:
Only Read operation can be carried out.
Read / Write:
Both Read and Write operations are possible
4
Data Handling:
Handles Database table
Data Handling:
Handles text file, XML file and Database table
5
Storage Capacity :
No storage
Storage Capacity :
Temporary Storage Capacity i.e., in-memory cache of data
6
Accessibility :
Can access one table at a time
Accessibility :
Can access multiple table at a time
7
Speed:
Much faster than DataSet
Speed:
Less faster than data reader

1 comment: