Why datareader is connected

The System. SqlClient and System. OleDb are containing these DataReaders respectively. From the following link you can see in details about these classes in C. Visual Studio Vs Visual Studio Understanding Matplotlib With Examples. Understanding Numpy With Examples. C Evolution. Disconnected Architecture in ADO. NET In disconnected architecture, the data retrieved from database can be accessed even when connection to the database was closed. Difference between Connected and disconnected architecture Connected Disconnected It is connection oriented.

Connected methods gives faster performance Disconnected get low in speed and performance. Datareader DataSet Connected can hold the data of single table Disconnected can hold data of multiple tables Connected you need to use a read only forward only data reader In Disconnected you cannot use.

We can update the data. I working with a big database what is the best way in performance -connected mode or disconnected mode- should I use? It depends on your needs. One of the most important differences is that a DataReader will retain an open connection to your database until you're done with it while a DataSet will be an in-memory object.

If you bind a control to a DataReader then it's still open. In addition, a DataReader is a forward only approach to reading data that can't be manipulated. With a DataSet you can move back and forth and manipulate the data as you see fit.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?