Connected and Disconnected Data Access Architecture

The Ado.Net Frame Work Supports Two Models of Data Access Architectures one is Connected Oriented architecture and second One is Disconnected Oriented Architecture.

ADO.Net Architecture

Complete Architecture

Connected Oriented Architecture in ADO.Net

• In connected oriented architecture client application will perform database operations on central database directly. 
• Before performing database operation connection has to open explicitly to central database as well as after completion of the database operation connection has to close explicitly 
• In this architecture programmer has to write the code to open the connection as well as to close the connection

Advantages:

•  Accessing data will be faster

Dis Advantages:

• It Increase network traffic
• Burden on database server
• Explicitly programmer has to write the code to open the connection as well as to close the connection.
• To overcome the above drawbacks we have to go for disconnected oriented architecture.

Disconnected Oriented Architecture in Ado.net:  

• In Disconnected oriented architecture client application will not perform all the database operations on central database instead of that it will depend on Local database.
• Central database will be part of remote machine but local database will be part of client machine.
• Whenever client application required some data it will fetch from the central database, will be fill into local database then only we can bind the data from local database to client application.
• If we want to perform any modifications like update,insert,delete,select. In this architecture we will perform on local database which we will reflect to central database directly(internally).
• In this architecture programmer doesn't require to open the connection explicitly as well as no need to write any code and no need to close connection. This will happen internally automatically.

Advantages:

• It reduce network traffic.
• Reduce the burden on database server which improves the performance of the application
• no need to write the code to open or to close the connection.

Dis Advantages:

• Accessing data will be slower.
• In this architecture local database object to creating with in the client machine which consumes client machine memory which affects the performance of client application.

Friends You Like My Post Please Share To Your friends Through Social Media Like Google +,Facebook,Twitter etc