ADO.Net supports 2 types of Models for accessing the data
from the Data Source.
i.
Connection-oriented Architecture
ii.
Disconnected Architecture
Connected Architecture
|
Disconnected Architecture
|
1. In this scenario, we need to be connected
with the data source for accessing the data.
|
1. In this scenario, we need to connect with the
data source only for loading the data.
|
2. This is Read Only
|
2. In this, we can manipulate the Data
|
3.Forward only
|
3. We can go both
forward and backward
|
4. Faster to access data from the data source as it
fetch the data in Row by Row order.
|
4. Performance is Slow as it has multiple tables which include
multiple Rows and Columns and constraints in it.
|
5. Here we use Data Reader class to hold the data
on the client machine.
|
5. Here we use the Data Set class.
|
For Video Description check this link
Data Set
