Finishing Document description for Powerdesign and EF

Recently through the Powerdesign->sqlserver->vs Way, the database design, creation, entity model generation and other links to open up, found that the model of VS did not explain, and then in the garden to find a bit, found a friend of the article.

Original address (Powerdesign abstract): http://www.cnblogs.com/stone_w/archive/2012/10/18/2729475.html

Original address (EF abstract): http://www.cnblogs.com/stone_w/archive/2012/10/25/2738345.html

Tool: http://eftsqldocgenerator.codeplex.com/releases/view/69447

　　1) PowerDesigner use

1.1) PowerDesigner Add Field description

Open table Design view = = Select the Columns column and click the "Comment" option in the "Columns and Filter" "=" channel and then add a column description.

1.2) Add Table index Double-click the table view to enter the table design page. + Click on indexs column + + add a list of indexes + + double click on new Index row = + click Columns + click "Add Columns" to select Add an indexed field and set the collation.

Ways to add a unique index: double-click the table view to enter the table design page. + Click on indexs column + + add a list of indexes + double-click the new index row = + General interface Select Unique, such as, then, click columns = Click "Add Columns"

　　　　

1.3) Add Table constraint Double-click the table view to enter the table design page. + Click on the keys column + + Add a column index + double-click the new index row + + click on "Add Columns" to add the Columns Constrained fields, set constraint rules.

1.4) Export picture Select the table you want to export and click on the toolbar edit + + click exportimage = Select path Export

2) Generation of EF documents

2.1) Use Microsoft Open Source project EFTSQLDocumentation.Generator.exe to generate an EF field summary (description) document.

: http://eftsqldocgenerator.codeplex.com/releases/view/69447,

2.2) After the download decompression is complete, the cmd command line enters the binary folder, calls the EFTSQLDocumentation.Generator.exe command (command below), completes the build,

Invoke command:

Format: eftsqldocumentation.generator.exe-c "Connection Database string"-i "xxx.edmx physical directory"

Example: Eftsqldocumentation.generator.exe-c "Data source=.;i Nitial catalog=db2012; User Id=sa; Password=sa; "-I" E:\DB2012.EDMX "

After the EFTSQLDocumentation.Generator.exe call is executed, the edmx file is refreshed, and the field summary (description) document has all been generated (sometimes it needs to be refreshed several times ...). ）。

Tools used for testing version: VS2010, EF 6.0, PD15.3

Finishing Document description for Powerdesign and EF