Defining Association Mappings

ADO.NET and ADO.NET CF support one-to-one, one-to-many/many-to-one, and many-to-many association mappings. PowerDesigner allows you to define standard association attributes like Container Type class, role navigability, array size and specific extended attributes for association mappings.

Open the Association property sheet and click the ADO.NET or ADO.NET CF Collection tab.

Define the appropriate options and then click OK.

The following options are available on this tab:

Option	Description
Order by	Specifies a table column (or columns) that define the iteration order of the Set or bag, together with an optional asc or desc.
Cascade	Specifies which operations should be cascaded from the parent object to the associated object.
Batch size	Specifies the batch load size.
Not found	Specifies how foreign keys that reference missing rows will be handled: ignore will treat a missing row as a null association.
Insert	Specifies that the mapped columns should be included in any SQL INSERT statements.
Update	Specifies that the mapped columns should be included in any SQL UPDATE statements.
Lazy	Specifies that this property should be fetched lazily when the instance variable is first accessed.
Many-to-Many operation side	Specifies the entry point when operating data in bi-directional many-to-many association. No matter the choice is RoleA or RoleB, the results are the same.