Teach you how to write a code generator (also an ORM)

Because the ORM still needs to be configured and entityobject is still required, it is inevitable to repeat the work. Here we will briefly look at how to implement CodeGenerator to reduce our labor intensity.
To put it bluntly, the principle of the Code Generator is quite simple. In a word, the main point is to obtain information about tables and fields.
Here we use sqlserver database as an example to see how to obtain
Obtain the tables and table information. Use the sp_tables stored procedure.
You can use sp_columns to obtain information about fields in a table.
Another way is to read the System View or system table.
After the metadata of the database is obtained, the generated code is a small case where the loop is followed again.
Note that it is recommended to read the system view (in the master database), which is more accurate. The execution results of sp_columns between 2000 and 2005 are different.