connected and disconnected architecture

Question

plz explain connected and disconnected architecture by using program

Mageshwaran R · Answer

Hi, Please refer the below link, it might helps you https://www.c-sharpcorner.com/UploadFile/8a67c0/connected-vs-disconnected-architecture-in-C-Sharp/

Jignesh Kumar · Answer

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.

Sanwar Ranwa · Answer

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