connected and disconnected architecture

https://www.c-sharpcorner.com/UploadFile/8a67c0/connected-vs-disconnected-architecture-in-C-Sharp/ 

Hi Asha,

 

In connetcted architecture we need connection keep open up to all operation done. Example is Datareader. connected architecture If you require data from the database you need to connect with database and fetch the data from there.

 

In dis-connected architcture once connection open we fetch all data in local memory then if we want to manipulate data on dataset we no need to connect to database we can do that on Dataset.

 

So Dataset is dis-connected and Datareader is example of connected architecture. 

Hello Asha

 

In disconnected architecture a DataSet is used for retrieving data from the database. Then no need for maintaining the connection also. All the operations can be performed with the data once retrieved. It won't cause traffic problems while working with the data.

 

In connected architecture a DataReader is used for retrieving data from the database. Here a connection is always maintained. Update, Delete, Read and Select operations can be performed as the data is accessed in the database, so that a connection must be be maintained. This can cause traffic problems.

 

You can check these Links for More details

 

https://www.c-sharpcorner.com/UploadFile/8a67c0/connected-vs-disconnected-architecture-in-C-Sharp/

http://helpingdotnet.blogspot.com/2011/10/connected-and-disconnected-architecture.html

http://csharp.net-informations.com/ado.net/ado.net-data-access-architecture.htm