Description
ADO.Net supports two types of architectures.
- Connection Oriented Architecture
- DisConnection Oriented Architecture
Description
The following figure shows you the detailed diagrammatic representation for the method 1.
Description:
In the method1, the connection will be established as follows.
- The client will establish the connection to the database.
- The client sends a request to perform the required operation to the server.
- The operation will be performed.
- The connection is closed to the server.
Description
The following figure shows you the detailed diagrammatic representation for the method 2.
Description:
In the method1, the connection will be established as follows.
- The client sends the request to the server to establish a connection.
- The client sends the request for the required data to the server.
- The client request is processed at the server and requested data is dumped into separate memory allocated for the client at the server. This memory is known as ResultSet.
- The link is created from the result set to the client application.
- Client Application starts reading the data from the resultset.
- Once reading the data is completed from the ResultSet, connection to the database is closed.
Disadvantages
The following are the disadvantages of the connected scenario.
- Burden on the server is more for large no.of clients.
- Connection to the database is maintained live through the client is analyzing the data which will waste the network resources unnecessarily.