DataReader And DataSet

Abhishek Jaiswal

12y1.4k

hello!

what is the difference btw DataReader And DataSet in sql server ?
:)

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta6y ago
Alternatively you can say that DataSet is a library and DataReader is you
Mageshwaran R6y ago

Hi,
Please refer the below link, it might helps you
https://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1
Rajanikant Hawaldar7y ago
Hi Dear, http://net-informations.com/faq/ado/dataset-datareader.htm
sudipta sanyal12y ago
DataSet
DataSet is a collection of in memory tables and datareader provides the ability to expose the data from database.
DataReader
DataReader is a stream which is readonly and forward only. It fetches the record from databse and stores in the network buffer and gives whenever requests. DataReader releasese the records as query executes and do not wait for the entire query to execute. Therefore it is very fast as compare to the dataset. It releases only when read method is called.

For more >>>>
https://www.c-sharpcorner.com/uploadfile/61b832/datareader-vs-dataset/