Today I stumbled upon John Papa’s article on the June 2004 issue of the MSDN Magazine. He discusses a question that every developer asks when dealing with ADO.NET. What do I use, the dataset or datareader object? This question should never be asnwered based on familiarity, rather based on design. Why design? Because as John discusses there are scenarios where one is better than the other.
Read this article that so clearly provides the information necessary to make those tough design decisions (notice the enphasis on the word desgin) [:)].