Releases a WPF software (source code) design helper class

Software features:

For SQL server2005, the Chinese name and remarks of the table/field are recorded on the table and field to assist in software design and development.

You can also export the table/field information as a TXT file in JSON format.

Platform and environment:

Vs2010, WPF,. Net 4.0, sqlserver2005

Development Reason:

In development, how to record the data dictionary (table structure) is a problem that our team has never solved.

The current method is to use powerdesign, Visio, or word to record data. However, the data structure changes frequently, such as adding certain fields. This requires that the original document be maintained during the change. Because the development process is not complete, this change is slowly out of touch with the document.

It is better to record the information on the database. We can write a software program to check whether each table has been annotated at any time. In other documents, you have to read these documents and compare them with the database to achieve the check effect.

So we have this software.

These data dictionaries can also be exported as TXT files in JSON format.

In addition, I have another plan to define the data dictionary as metadata and further extend it to automatically generate the data dictionary instead of dragging the control to view and modify the page, so as to automatically build the query, this is all an afterthought.

 

There are not many software functions, so I am very happy to put the source code on. If anyone has extended, please feel free to give me feedback.

The first time I used WPF for development, the interface was simple.

 

 

You need to compile it. Note that you need to define the database connection string and export file path in the configuration file settings. settings.