Environment In ASP.NET

Question

Hi What is the difference between connected environment and a disconnected environment?

Satyapriya Nayak · Answer

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.