What is the difference between connected and disconnected architecture in ADO NET

All Subject

Question - What is the difference between connected and disconnected architecture in ADO.NET?

Answer -

Connected architecture	Disconnected architecture
It is connection-oriented.	It is not connection-oriented.
DataReader is a connected architecture.	DataSet is a disconnected architecture.
High speed and performance are given by connected methods.	Disconnected methods are low in speed and performance.
Data persistence is not possible using DataReader.	Data persistence is possible using DataSet.
It carries the single table data.	It carries data from multiple tables.
We can’t update the data as it is read-only.	Here we can update the data.

Show all Coment

Name:

Email:

Ado.net Interview Questions and Answers