Generating ADO.NET and ADO.NET CF Persistent Objects

Microsoft ADO.NET and ADO.NET CF are database-neutral APIs. PowerDesigner provides enhancements to them to support:

Cascade Association: one-to-one, one-to-many, many-to-one, and complex many-to-many associations.
Inheritance: table per class , table per subclass, and table per concrete class hierarchies.
Value Types
SQL statements: including complex SQL statement like Join according to OOM model and PDM model.

PowerDesigner also supports the design of .NET classes, database schema and Object/Relational mapping (O/R mapping), and can use these metadata, to generate ADO.NET and ADO.NET CF persistent objects including:

Persistent .NET classes (POCOs)
ADO.NET O/R mapping classes (ADODALHelper)
DAL factory
Data Access Objects (DAL)

Adding ADO.NET or ADO.NET CF Support
PowerDesigner provides an ADO.NET and ADO. Net CF extended model definitions to generate persistent files for these frameworks.
Class Mappings
There are two kinds of classes in ADO.NET and ADO.NET CF:
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.
Defining Inheritance Mappings
ADO.NET and ADO.NET CF support the three basic inheritance mapping strategies:
Generating Code for ADO.NET or ADO.NET CF
In order to generate code for ADO.NET or ADO.NET CF, you must have the .NET Framework 2.0 Visual Studio.NET 2005 or above installed:

Parent topic: Generating .NET 2.0 Persistent Objects and Windows Applications