Chapter 11 Generating .NET 2.0 Persistent Objects and Windows Applications

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)