This is a simple database document generation tool, the main implementation of SQL Server generation instructions document of the gadget, is not perfect, the main can be the database table and table detailed field information, export to
In Word, you can make it easier for developers to learn about databases or to write technical documentation.
The main technology used in the c#+dapper+npod, development tools for Vs2015, based on the Net4.5 framework.
Implementation ideas:
1, first get the database string, test the link is successful,
2. Get a list of databases for this server through scripting.
3. Find all data tables of the database according to the database
4, through the script to find the data table all the field information
5. Use Npoi technology to export the information to Word.
The effect is as follows:
Document Effects
At present, the function is relatively simple, the follow-up will gradually improve, of course, their own limited technology, welcome experts more guidance!
GitHub Address: Https://github.com/hgmsq/SqlToDocTool
Original SQL Server database generates a simple explanatory document gadget (with source code)