Connected Architecture :
* The connection must be kept open in linked architecture in order to access the data retrieved from the database. Connection, DataReader, Command, and Transaction are the classes that make up the Connected architecture.
* You go to the database on a regular basis to perform any CRUD (Create, Read, Update, and Delete) operations. This causes a lot of traffic to the database, but it's usually faster because you're only conducting tiny operations.
* DataReader is a Connected Architecture because it keeps the connection open until all of the rows have been fetched one by one.
Disconnected Architecture :
* Even if the database connection is closed in a disconnected architecture, data retrieved from the database can be accessed. Connection, CommandBuilder, DataAdapter, DataSet, and DataView are the classes that make up the disconnected architecture.
* We obtain and save a record set from the database so that you may execute numerous CRUD (Create, Read, Update, and Delete) actions on the data without having to reconnect to the database.
* Because all records are brought at once and the database connection is not kept alive, DataSet is a Disconnected Architecture.
