Wednesday, January 1, 2014

Difference between DataReader and DataSet

-DataSet can represent an entire relational database in memory,completely with table relation and views.
-DataSet is a disconnected architecture while DataReader has live connection while reading data.
-If we want to Cache data and want to pass in different layer DataSet is the best thing to choose.
-DataSet support XML.
-When we need to access data from more than one table DataSet is the best choice.
-If we need to move back while reading records DataReader does not support.
-If you want to quickly read and display record on page DataReader is good choice to use.

0 comments:

Post a Comment