Generating ADO.NET and ADO.NET CF Persistent Objects

Microsoft ADO.NET and ADO.NET CF are database-neutral APIs.

PowerDesigner supports ADO.NET and ADO.NET CF through extension files that provide enhancements 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.

To enable the ADO.NET or ADO.NET CF extensions in your model, select Model > Extensions, click the Import tool, select the ADO.NET or ADO.NET Compact Framework file (on the O/R Mapping tab), and click OK to attach it.

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)

ADO.NET and ADO.NET CF Options
To set the database connection parameters and other ADO.NET or ADO.NET CF options, double-click the model name in the browser to open its property sheet, and click the ADO.NET or ADO.NET CF tab.
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