What is difference between Connected and Disconnected Environment

Connected Environment :

• Connected Environment needs a constantly connection of user to data source while performing any operation.
• Only one operation can be performed at a time in connection Environment.
• DataReader is used in Connection Environment.
• It is slower in speed.
• We get updated data in it.

Disconnected Environment :

• Disconnected Environment doesn't need any connection.
• Multiple operations can be performed.
• DataSet is used in it.
• Disconnected Environment has a good speed.
• There is a problem of dirty read.