Convert the database table structure to an entity class (applicable to VB.net and C #. Net)

To facilitate development, you want to convert a database table (View) to an object class chart.

 

If you use EA to directly import the database table, the generated is not a class, or the table structure and the association between the tables (equivalent to the E-R diagram ). For example:

 

 

To convert a database table (View) structure to an object class, two steps are required:

(1) convert the database table (View) structure to the correspondingProgramming LanguageOfCode(This code can be directly imported to the project. You can also edit the code after the EA generates a class diagram, and then import the code to the project)

(2) import the code to the EA to generate a class diagram.

 

STEP (1) with the help of another small software, that is, entityscodegenerate, you can search and download it online.

,

Open Software: set up (very simple)

The generated code file is as follows:

 

Open the relevant project in EA and navigate to the object chart: Right-click to import --vb.net from the source file

 

Locate the generated code file and select all.:

Open to generate the required class diagram (for example ):