Table of Content

Part 2 - Working with Object-Relational Mapping

Chapter 14 - Introduction to Object-Relational Mapping

Introduction
Key Benefits

Chapter 15 - Getting Started with Object-Relational Mapping

Database Configuration
Database Configuration for Java Project
Configuring Multiple Database Settings
Database Configuration for .Net Project
Configuring Multiple Database Settings
Specifying JDBC Driver File, .NET Driver File and Adapter File
Automatic Downloading Driver files
Automatic Downloading JDBC Driver
Automatic Downloading .NET Driver and Adapter File
Supported Database, JDBC Drivers and .NET Drivers
Supporting Multiple Database
Assigning Data Types from Multiple Database
Porting to Other Database
Displaying Data Type based on Default Database

Chapter 16 - Using ORM Wizard

Introduction
Generating Code from Database

Chapter 17 - Object Model

Introduction
Object Models
Creating a Class Diagram
Drawing a Class Diagram
Creating a new Class element to the Class Diagram
Creating a new ORM-Persistable Class element to the Class Diagram
Modifying the Class Specification
Adding new Attribute to the Class
Adding Association to the Classes
Editing Association Specification
Setting Stereotypes of classes be ORM Persistable
Synchronizing from a Data Model to an Object Model
Defining Package for Classes
Specifying Inheritance Strategy
Specifying Collection Type
Defining ORM Qualifier
Customizing SQL
Mapping an Object Model to a Data Model
Mapping Classes to Entities
Mapping Attributes to Columns
Mapping Data Type
Mapping Primary Key
Mapping Association
Mapping Aggregation
Mapping Composite Aggregation
Mapping Multiplicity
Mapping Many-to-Many Association
Mapping Inheritance/Generalization
Using Table per Class Hierarchy Strategy
Using Table per Subclass Strategy
Using Mixed Strategies
Mapping Collection of Objects to Array Table
Mapping Object Model Terminology
Showing Mapping between Object and Data Models by ORM Diagram
Creating an ORM Diagram from Existing Diagrams
Drawing an ORM Diagram
Creating ORM-Persistable Class and Mapping Entity to the ORM Diagram
Creating Associated ORM-Persistable Class to the ORM Diagram
Creating Mapping Entity to the ORM Diagram
Showing Attribute Mapping
Supporting Real-time Synchronization
Forming a Class Diagram
Modifying ORM-Persistable Class
Modifying Entity
Switching the View of Mapping
Using ORM Pane
Class View
Database View
Reverse Engineering Java Classes to Object Model
Reverse Engineering Hibernate Model to Object Model

Chapter 18 - Data Model

Introduction
Entity Relationship Diagram
Creating an Entity Relationship Diagram
Drawing an Entity Relationship Diagram (ERD)
Creating a new Entity element to the ERD
Modifying the Entity Specification
Adding new Column to the Entity
Adding Relationship to the Entities
Editing Relationship Specification
Reverse Engineering an existing Relational Database
Step 1: Select Language
Step 2: Database Configuration
Step 3: Selecting Tables
Synchronizing from an Object Model to a Data Model
Specifying Index Column
Using the ID Generator
Defining Discriminator
Defining Discriminator Column for Entity
Defining Discriminator Value for Class
Creating an Array Table
Defining an Array Table
Defining an Array Type for Attribute in Class
Creating a Partial Table
Splitting Table
Converting to a Partial Table
Copying SQL statements from Tables
Copying SQL statements from Specified Scope
Mapping a Data Model to an Object Model
Mapping Entities to Classes
Mapping Columns to Attributes
Mapping Data Type
Mapping Primary Key
Mapping Relationship
Mapping Identifying Relationship
Mapping Non-identifying Relationship
Mapping Cardinality
Mapping Many-to-Many Relationship
Mapping Array Table to Collection of Objects
Mapping Data Model Terminology

Chapter 19 - Database Schema

Introduction
Generating Data Definition Language and Database
Generating Database from Data Model
Using Database Code Generation Dialog Box
Generating Database for Java Project
Generating Database for .NET Project
Using Wizard
Generating Database from Object Model
Mapping Data Model to Data Definition Language

Chapter 20 - Implementation

Introduction
ORM-Persistable Class
Generating ORM-Persistable Class Model
Using Database Code Generation Dialog Box
Configuring Code Generation Setting for Java
Configuring Code Generation Setting for C
Using ORM Wizard
Generating ORM-Persistable Class from Object Model
Using Database Code Generation Dialog Box
Using ORM Wizard
Generating ORM-Persistable Class from Database
Mapping Object Model to ORM-Persistable Java Class
Mapping Classes, Attributes and Data Type
Mapping Data Type
Mapping Primary Key
Mapping Generalization
Mapping Association and Multiplicity
Mapping Navigable Association
Mapping Object Model to ORM-Persistable .NET Class
Mapping Classes, Attributes and Data Type
Mapping Data Type
Mapping Primary Key
Mapping Generalization
Mapping Association and Multiplicity
Mapping Navigable Association

Chapter 21 - Manipulating Persistent Data with Java

Introduction
Using ORM-Persistable Class
Model API
Manipulating Attributes
Manipulating Association
Smart Association Handling
One-to-One Association
One-to-Many Association
Many-to-Many Association
Using Collection
Standard Association Handling
One-to-One Association
One-to-Many Association
Many-to-Many Association
Using Collection
Persistent API
Using Static Method
Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying
Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class
Using Factory Class
Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying
Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class
Using POJO
Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying
Loading a Collection of Persistent Objects
Using DAO
Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying
Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class
Using Criteria Class
Applying Restriction to Property
Sorting Retrieved Records
Setting the Number of Retrieved Records
Loading Retrieved Records
Using Transactions
Using ORM Implementation
Inserting an ORM Implementation Class
Code Sample
Running the Sample Code
Creating Database Table
Inserting Record
Retrieving and Updating Record
Retrieving Record by ORM Qualifier
Retrieving Record by Criteria Class
Deleting Record
Retrieving a Number of Records
Retrieving a Number of Records by ORM Qualifier
Retrieving a Number of Records by Criteria
Dropping Database Table
Running the Script File

Chapter 22 - Manipulating Persistent Data with .NET

Introduction
Using ORM-Persistable .NET Class
Model API
Manipulating Attributes
Manipulating Association
Smart Association Handling
One-to-One Association
One-to-Many Association
Many-to-Many Association
Using Collection
Standard Association Handling
One-to-One Association
One-to-Many Association
Many-to-Many Association
Using Collection
Persistent API
Using Static Method
Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying
Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class
Using Factory Class
Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying
Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class
Using POJO
Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying
Loading a Collection of Persistent Objects
Using DAO
Creating a Persistent Object
Loading a Persistent Object
Updating a Persistent Object
Deleting a Persistent Object
Querying
Loading a Collection of Persistent Objects
Using ORM Qualifier
Using Criteria Class
Using Criteria Class
Applying Restriction to Property
Sorting Retrieved Records
Setting the Number of Retrieved Records
Loading Retrieved Records
Using Transactions
Using ORM Implementation
Inserting an ORM Implementation Class
Code Sample
Running the Sample Code
Creating Database Table
Inserting Record
Retrieving and Updating Record
Retrieving Record by ORM Qualifier
Retrieving Record by Criteria Class
Deleting Record
Retrieving a Number of Records
Retrieving a Number of Records by ORM Qualifier
Retrieving a Number of Records by Criteria
Dropping Database Table
Applying .NET Persistence Class to different .NET Language

Appendix D - JDBC and .NET Drivers

JDBC Drivers
.NET Drivers

Appendix E - Glossary