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 , click the Attach an Extension 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)