The database row data models provide storage of data until the data is inserted and perform error checking on the data as it is added to the row data model and prior to the insertion into the database. The base class for each database row data model is the DataTableItemBaseModel class.

The CDataTableModel is the base class for all database table classes. It contains aggregations of the DbColumnParameterData and SqlCmdParameter classes. The purpose of the DbColumnParameterData class is to provide necessary information for each column in a database table. The purpose of the SqlCmdParameter class is to provide information about every parameter in a stored procedure call. The three dictionaries in each CDataTableModel provide quick look up for the SqlCmdParameter aggregations based on 3 different naming schemes, the common name within the application, the column name in the database table and the parameter name in the stored procedure. This file contains almost all the calls to stored procedure. Each class that inherits from this class defines the names of the tables and the stored procedures. This allows for generic SQL database calls.

Each instance of a database table row model references its data table model to acquire the DbColumnParameterData and the SqlCmdParameter for error checking and validation purposes.

Figure 4 The CDataTableModel and the DataTableItemBaseModel both aggregate the SqlCmdParameter class

Each public parameter in a DataTableItemBaseModel super class references an instance of the SqlCmdParameter class.

Figure 5 All of the super classes of the DataTableItemBaseModel currently in use

This is an exaample of a super class of the DictionaryTableModel. In the user interface category was renamed as Genre.

This is an example of one of the more complex implementations of the CDataTableModel class.

This is the implementation of the DataTableItemBaseModel for the previous table.

The database row data models provide storage of data until the data is inserted and perform error checking on the data as it is added to the row data model and prior to the insertion into the database. The base class for each database row data model is the DataTableItemBaseModel class.

The CDataTableModel is the base class for all database table classes. It contains aggregations of the DbColumnParameterData and SqlCmdParameter classes. The purpose of the DbColumnParameterData class is to provide necessary information for each column in a database table. The purpose of the SqlCmdParameter class is to provide information about every parameter in a stored procedure call. The three dictionaries in each CDataTableModel provide quick look up for the SqlCmdParameter aggregations based on 3 different naming schemes, the common name within the application, the column name in the database table and the parameter name in the stored procedure. This file contains almost all the calls to stored procedure. Each class that inherits from this class defines the names of the tables and the stored procedures. This allows for generic SQL database calls.

Each instance of a database table row model references its data table model to acquire the DbColumnParameterData and the SqlCmdParameter for error checking and validation purposes.

Figure 4 The CDataTableModel and the DataTableItemBaseModel both aggregate the SqlCmdParameter class

Each public parameter in a DataTableItemBaseModel super class references an instance of the SqlCmdParameter class.

Figure 5 All of the super classes of the DataTableItemBaseModel currently in use

This is an example of a super class of the DictionaryTableModel. In the user interface category was renamed as Genre.

This is an example of one of the more complex implementations of the CDataTableModel class.

This is the implementation of the DataTableItemBaseModel for the previous table.