PowerDesigner Create a database model, generate model classes automatically, generate SQL scripts automatically

One, save the working space

Second, file-new model

Iii. Creating a new database table

Iv. Modifying database table names

V. Setting up a database table field

Vi. Tools->generate object-oriented Model

Open the Details tab, remove the "Check model" and convert the name to encode

Open general, select the language you want to build, apply and confirm

Vii. language->edit Current Object language->profile->attribute->templates->definition

Rewrite the code generation template application confirmation to your own requirements, such as my C # Template:

.if(%isvalidattribute%)///<summary>///[%Name%]///</summary>.if(%comment%)/// <remarks>[%comment%]/// </remarks>. endif.if(%multiple% = =false) and (%isindexer% = =false)[%visibility%][%flags%]%datatype%%code%[=%initialvalue%] {Get;Set; }.Else[%visibility%][%flags%]%datatype%[%arraysize%]%code%[=%initialvalue%] {Get;Set; }. Endif.endif

Viii. language->generate C # code->generated Files

Select the model you want the generated code for

Ix. Database->change Current DBMS

Select the SQL format you want to generate

X. Database--Build database

Confirm the build can

PowerDesigner Create a database model, generate model classes automatically, generate SQL scripts automatically