Differentiate between connected and disconnected architecture.

Question

Nishi Tiwari · Answer

Connection Oriented Architecture The architecture which needs an open connection to access or fetech the data from the database is known as Connection-Oriented Architecture. Following are the classes on which Connection Oriented Architecture is built on: Connection – Which is used to establish the connection between the front end and back end. Command – Enables access to the database commands to return data, modify it, run the stored procedures, and send or retrieve parameter information. Data Reader – Used to read the data from the Source. Provides a high-performance to data from data source. Data Adapter –Works as a Mediator between the front end and back end which doesn’t have the feature of containing data within this, so it uses Dataset which is also a result set. – It also provides a bridge between DataSet and data source. –Uses Command Objects to execute commands. As Connected architecture must needs a connection for every transaction and so creates much traffic to the database since it does many trips. It shows a very high impact on the performance when the transaction will have many commands i.e. for larger transactions. If it is working with smaller transactions it will be normally much faster. Disconnected Oriented Architecture In this architecture data can be retrieved from the database even when the connection gets disconnected or closed then it is known as Disconnected Oriented Architecture. Following are classes on which disconnected architecture is built on: Command Builder – We can generate insert, update and delete commands on a single database table for a data adapter. Data Set – Contains the set of Data Tables (Data Table is a set of Data Rows and Data Columns) Data View – It is a view of the table available in DataSet which can be used to perform insert, update and delete commands in case of Data Set and can also be used to find, sort and filter the records. Disconnected architecture is a method by which we retrieve the result set from the database and giving the user ability to perform CRUD operations like insert, update and delete and also no traffic issues will also get occurred because even though the connection was gone we will get the data already stored into dataset object. By keeping connections open for only a minimum period of time, ADO .NET conserves system resources and also provides maximum security for databases and also has less impact on system performance. Any changes made to data in DataSet does not show the effect on the database directly, so to save the changes we need to use Update() method of Data Adapter. Can be used with multiple data sources, used with XML data, or also used to manage data local to the application. Difference between Connected and disconnected architecture CONNECTED It is connection oriented. Connected gives faster performance. Datareader is used as object Connected can hold the data of single table only . Connected we need to use a read only forward data reader. Data Reader cannot persist the data. It is Read only, so we can’t update the data. DISCONNECTED It is disconnection oriented. Disconnected gives low in speed and performance. DataSet is used as object . Disconnected can hold data of multiple tables . In Disconnected we cannot use this. Data Set can persist the data . We can update the data easily.

forum

Differentiate between connected and disconnected architecture.

Can you answer this question?

1 Answers