Connected Oriented Architecture in ADO.Net

Ado.net is a native driver designed by Microsoft for .net technology which is used to interact with middle ware or database directly.Without Ado.net, it is impossible to write the database related code in .Net.

Microsoft Designed Native Drivers:

1.DAO(Data Access Object)
2.RDO(Remote Data Object)
3.ADO(Active X Data Object)

Connection Oriented Architecture:

In this first connection is established to the server then we form required operations on the database and connection to the database is closed.

Steps:

1.Connection is established from client to server
2.Client sends request for the required data
3.Client request is processed and result is transferred to network buffer created at server side.
4.Link is created from network buffer to client
5.Client will read the data from network buffer.After completion of interaction connection to the database is closed.

Disadvantages of Disconnected architecture:

->When number of clients increases burden on the server increases
->Though client is analyzing the data, connection to the database is maintained live. This will waste the network resources.