ADO.NET connected mode vs disconnected mode
ADO.NET can work on either connected mode or disconnected mode.
DataSet vs DataReader
DataSet is an in-memory representation of a database, providing a consistent relational programming model no matter what format of data source. It contains multiple data tables and their relationship and constraints information.