DataReader vs DataSet: A Guide to Connected and Disconnected Data Access
DataReader and DataSet are two significant data access models that can greatly impact the performance, scalability, and responsiveness of your.NET application. The connected model, powered by DataReader, keeps a live connection open and streams data forward-only to maximize speed and minimize memory usage. The disconnected model, implemented through DataSet, takes the opposite approach. It loads data into memory so you can edit and reuse it without constant database interaction.