Summary

This chapter presented the ADO.NET classes and features they provide. We connect to the database using the ADO.NET Connection object of the relevant data provider. We have two options of working with a database: connected mode and disconnected mode. The former represents the classic ADO model. With the latter we may achieve better performance for our database applications, since we may perform the operations on data locally and then propagate changes to the database.

When working in connected mode, we use data readers to fetch the data. In the disconnected mode, the data is placed in the datasets that are independent of any data provider. Data adapters mediate between the database and dataset when transferring data from and to a database.

We presented the database version of the Stock Management System. There we illustrate most of the techniques of working with databases that we acquired in this chapter.