1.

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

Answer»
CONNECTED architectureDisconnected 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.


Discussion

No Comment Found