Which should be prefer in which condition DataSet and DataReader
| The data reader is helpful when we have number of tables and large query too and database in non-uniform pattern and we need not execute the large no. of queries on few particular table. On the other hand when we have low number of table and most of the time you need to execute queries on these fewer tables, we should go for the dataset. | |