What Different Type Of Connection Architecture We Have In Asp.net?

1.	What Different Type Of Connection Architecture We Have In Asp.net?
Answer» There TWO types of connection in Ado.Net.They are connected Architecture and disconnected architecture: In connected architecture, we don't have to open and CLOSE the connection MANUALLY. A data-reader is used in connected architecture to read the data from the database row by row. This reduces the performance efficiency as we have to each TIME HIT the server each time and the traffic for the server also increases. In disconnected architecture, we have to manually open and close the connection. A data-set or data-table is used in disconnected architecture to read the data from the database at a time and store it in memory. There two types of connection in Ado.Net.They are connected Architecture and disconnected architecture:

Answer»

There TWO types of connection in Ado.Net.They are connected Architecture and disconnected architecture:

In connected architecture, we don't have to open and CLOSE the connection MANUALLY. A data-reader is used in connected architecture to read the data from the database row by row. This reduces the performance efficiency as we have to each TIME HIT the server each time and the traffic for the server also increases.
In disconnected architecture, we have to manually open and close the connection. A data-set or data-table is used in disconnected architecture to read the data from the database at a time and store it in memory.

There two types of connection in Ado.Net.They are connected Architecture and disconnected architecture:

Discussion