Project Overview: Application Design
The remainder of Part III of the tutorial consists of a series of instructions and exercises that guide you through the completion of a simple contact management system. The system allows users to view and update contact information (contacts and their phone numbers) stored in Caché. The application consists of a .NET Windows Form connected to a Caché database using ADO.NET and the relational interface to the CMP. The database schema and the Windows form have been provided for you. You will only be adding the code that connects the form to Caché.
The application uses ADO.NET's “Disconnected” approach. Here is how it works:
The application creates a DataSet object that mimics the layout of the Caché tables.
CacheDataAdapter objects connect to Caché and fill the DataSet with data. There are two data souces: the Contact table and the PhoneNumber table.
Responding to user requests, the application makes changes to the DataSet data.
The DataAdapter objects reconnect to Caché and both update the database and refresh the DataSet data.
The tutorial provides a skeleton solution that you can use to complete the instructions and exercises. The tutorial also provides a complete solution that you can install and execute. For instructions on locating and configuring these files, see the Note below.
Read Example and Exercise Files for the location of the tutorial files and instructions for installing and executing them.