"C #" Excel-made data tables, SqlParameter code generation tools

Reprint please specify the source http://www.cnblogs.com/Vulpers/

Made a small code generation tool to quickly generate some very repetitive code when creating a new data table, currently supporting only SQL Server database and C # language, roughly the following functions

First, write the fields and field properties in the table that you need to create a new table, such as:

If the cell turns red during the input process, the cell needs to fill in the contents or the content is incorrect.

After that is the function of the above three buttons

Database script:

Click to go to the page, copy the code into the database management tool and execute to generate the table

SqlParameters:

This page is divided into left and right two pieces, need to be copied and pasted separately

C#model

Go back to the table design page and choose Sheet1 from the tabs below.

The various types of correspondence are written on the data source page, and you need to make your own changes

Download Link: https://github.com/VulperVoid/PersonalTools

PS: Because it is temporary write, inevitably there are many shortcomings and shortcomings, I hope you can put forward valuable suggestions to improve the small tool to make it more convenient

"C #" Excel-made data tables, SqlParameter code generation tools