Connected and Disconnected Architecture –

  • Connected and Disconnected Architecture –

  • ADO.NET (Active x Data Object) is a mediator between the front end and back end that interacts with the client-side application and server-side application which supports two types of Data Accessing models, one is Connection-oriented and Disconnected oriented.
  • ADO.NET leverages the power of XML for accessing data using disconnected architecture. It was completely designed with XML classes in .NET Framework.
Note: Before going into this article you should have a basic understanding of SQL queries on select, insert, update and delete commands.
Connection String

Connection string plays a very crucial role in connecting your front-end application and a back-end application. It’s a normal string which contains the information to establish the connection between the backend Database and application and secured information such as user Id and password.

  • Usually, Data Providers uses this connection string which contains parameters that are needed for establishing the connection.
  • Let’s have a look at Data Providers that are supported by.Net Framework.
  • List of Data providers which is supported by.Net Framework.


SQL server Provider connection string:

connetionString=”Data Source=ServerName;Initial Catalog=Databasename;
User ID=UserName;Password=Password”

OLEDB Provider connection string:

connetionString=”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=yourdatabasename.mdb;”

ODBC Provider connection string:

connetionString=”Driver={Microsoft Access Driver (*.mdb)}; DBQ=yourdatabasename.mdb;”

Connection Oriented Architecture

The architecture which needs an open connection to access the data from the database is known as Connection-Oriented Architecture.
Following are the list of classes on which Connection Oriented Arch is built on:

  • Connection

    – Used to establish the connection between the front end and back end.

  • Command

    – Enables access to database commands to return data, modify data, run stored procedures, and send or retrieve parameter information

  • Data Reader

    – Used to read the data from Source. Provides a high-performance stream of data from data source.

  • Data Adapter

    –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 a result set.
    –Also provides a bridge between DataSet and data source.
    –Use Command Objects to execute commands.

As Connected architecture needs a connection for every transaction and creates much traffic to the database since it does several trips. It shows a very high impact on performance when the transaction has many commands i.e. for larger transactions. If it’s doing smaller transactions it is normally much faster.

Connected Architecture
Connected Architecture

SqlConnection con = new SqlConnection(“connection String”);
SqlCommand cmd = new SqlCommand(“query”,con);
SqlDataReader dr = cmd.ExecuteReader();
//cmd.ExecuteNonQuery(); or cmd.ExecuteScalar();

Note: In this Connected oriented arch the application stays connected even when it’s not doing any operations on the database. To overcome this ADO.NET introduced a new component called DataSet which is a central component in Disconnected Architecture.
DataSet ds = new DataSet( );

Disconnected Oriented Architecture

Disconnected Oriented Architecture
Disconnected Oriented Architecture

The architecture in which data can be retrieved from the database even when the connection gets disconnected or closed is known as Disconnected Oriented Architecture.
Following are the list of classes on which disconnected arch is built on:

• Command Builder – 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’s a view of the table available in DataSet. Can be used to perform insert, update and delete commands as in case of Data Set. Can be used to find, sort and filter the records.
Connected Architecture
Connected Architecture

• Disconnected architecture is a method of retrieving the result set from the database and giving the user the ability to perform all CRUD operations like insert, update and delete. No traffic issues will get occurred because even though the connection was gone data will be get already stored into dataset object.
• By keeping connections open for only a minimum period of time, ADO .NET conserves system resources and provides maximum security for databases and also has less impact on system performance.
• Any changes to data in DataSet doesn’t show the effect on the database directly, to save the changes need to use Update() method of Data Adapter.
• Can be used with multiple and differing data sources, used with XML data, or used to manage data local to the application.

Da.Update(ds,”Table Name”);

Differences between connected and disconnected architecture

connected and disconnected architecture
connected and disconnected architecture

2 thoughts on “Connected and Disconnected Architecture –”

  1. very helpful article for learning of dot net…….
    well explained……….
    really good job……
    thank you so much……….
    keep updating…….

Leave a Reply

Your email address will not be published. Required fields are marked *