ADO.NET - SPLessons

ADO.Net Disconnected Scenario

Home > Lesson > Chapter 4
SPLessons 5 Steps, 3 Clicks
5 Steps - 3 Clicks

ADO.Net Disconnected Scenario

ADO.Net Disconnected Scenario

shape Description

In disconnected architecture, it is not required to write code to establish a connection and close the connection. At the time of sending request for connection,  Connection is automatically opened and also closed automatically once data is dumped into the client machine. When the client updates the data to database, connection is established automatically and also closes the connection automatically after the updation.

shape Conceptual figure

The following diagram shows you the architecture of the disconnected Scenario.

shape Description

  1. Client sends the request to the required data.
  2. Client request is process at the server and the data is dumped into the client machine known as processed area.
  3. Client starts interacting with process area data.
  4. Once client interaction completes process area data can be updated to the server.

shape Advantages

  • No burden on the server for any no.of clients.
  • Network resources will not be wasted though  client is analyzing the data.

shape Disadvantages

  • Disconnected architecture can not be used efficiently where immediate updation of the data is required.
  • Disconnected architecture can not be used where the data is most important and also security is major concern.