Difference between disconnected &Connection oriented model

• In disconnected architecture, the Dataset reads the data into the local memory buffer and perform the data operations (Insert, Update and Delete) locally to the buffer and finally the changed Dataset is stored in actual database as a batch when needed. This greatly reduces the network traffic and results in the better performance.
  
• In the connection oriented architecture, it is your responsibility to open and close the database connections. You have to establish the DB connection, perform the required operations to the DB and when you are done, close the DB connection.