Performing Database Updates with DataSets
The architecture for performing database updates has changed significantly with the introduction of ADO.NET. ADO.NET has been designed to better facilitate development of multitier applications that scale to large database sizes and large numbers of clients. This has had some important consequences, in particular:
- ADO.NET applications usually segregate application logic on the client from business and data integrity computations on the middle and database tiers. In practical terms, this means that the typical application will have more of a batch or transactional nature with fewer (but larger) interactions between client application and database.
- ADO.NET applications have more control (in comparison to ADO and its predecessors) over exactly how updates are processed.
- ADO.NET allows applications to propagate changes by means of stored procedures that are stored in the backend database, instead of directly manipulating a row of a database table. This is a recommended practice.