Essential ADO.NET

5.6. Updating a Database through DataAdapter

The disconnected update pattern is a good choice when you have a single user per DataSet. The DataSet class supports this pattern of data access. Data is read into DataSet using DataAdapter. The DataAdapter class can sever the connection, and multiple updates can be made in disconnected mode. DataSet keeps a cache of these updates. The changes are visible immediately within DataSet itself but can be flushed back to a data store. Attempting to set a DataColumn to an incorrect value (for example, attempting to set a non-nullable column to DBNull.Value) results in an error at column update time in DataSet, rather than when the change is flushed to a database. This means that by specifying constraints ...