Chapter 9 Working with Object-Oriented Models

Creating an object to relational mapping for a class

Steps To create an object to relational mapping for a class:

  1. Double-click a class to display its property sheet, then click the Mapping tab.
  2. Click the Create Mapping tool beside the Mapping list to create a mapping for the current class. If several data sources are available, you have to select one or several data sources in the selection list and click OK.
  3. In the Class Sources sub-tab, click the Add Objects tool to select the source tables and views you want to map to the current class and click OK.

    The name and code of the tables and views appear in the list.
  4. Click the Attributes Mapping sub-tab in the Mapping tab and click the Add Mapping tool in the toolbar.
  5. Select the attributes that will be mapped to columns in the source tables or views and click OK.

    The selected columns appear in the first column of the list.

    Note   Generate mapping
    You can click the Generate Mapping tool to automatically create the mapping between columns and attributes with identical name or code in the data source and the current model

  6. Click the down arrow in the "Mapped to" column to select the column in the data source table to which the selected attribute will be mapped.

    You have to repeat this operation for each attribute you want to map to the data source.
  7. Click the Criteria tab if you want to specify join criteria between the source tables or views.
  8. Select the different queries tabs to visualize or modify the SQL statements.
  9. Click OK.

 

Copyright (C) 2006. Sybase Inc. All rights reserved.