Hello everyone, I am a wolf at the end of the desert.
1. project information
今天介绍一个.NET开源项目 SmartSQL，站长是从张队分享的一篇公众号文章开源：一款基于.Net开发提升开发效率的强大多功能工具箱了解到的，今天通过查看该项目源码，非常值得二次推荐，本文从源码及功能两点介绍。
About this open source project:
- Warehouse address: gitee.com/dotnetchina/SmartSQL
- 开源协议：Apache-2.0
- Project goal: A convenient and fast database document query and generation tool, and is committed to becoming a metadata management tool that helps enterprises quickly realize digital transformation.
2. Simple analysis of source code
The source code includes three projects: SmartSQL, SmartSQL.DocUtils and SmartSQL.Framework. Let's simply check it out, and friends who are interested in the source code can check it out.
2.1. SmartSQL
这是主工程，是一个WPF项目，里面使用了AduSkin、AvalonEdit、HandyControl、FontAwesome.WPF等第三方库，通过该工程可以学习怎么使用第三方控件库、字体库等，后面通过看工具截图可看控件库的实用效果。
In addition, as shown in the screenshot of the code file above, the specific implementation of each tool is also in this project. If you have relevant functional requirements in your daily work, you can directly refer to this project. The list of tools is as follows.
2.2. SmartSQL.DocUtils
This project is a class library that encapsulates the import and export of various data files. Through the introduction of the warehouse, you will know how rich the supported files are:
SmartSQL is a convenient and fast database document query and export tool! Starting from the initial support for SqlServer database and CHM document formats, through continuous exploration and development, brainstorming and continuous improvement, it has gradually supported the export of document formats such as Word, Excel, PDF, Html, Xml, Json, and MarkDown. At the same time, it also extends the support for document query and export functions in various databases including SqlServer, MySql, PostgreSQL, SQLite, etc.
2.3. SmartSQL.Framework
As you can see from the name, this class library is the core project of this project, that is, the core code base for database document query and export. Comrades interested in the implementation of database operations can view it.
3. function display
设置SmartSQL工程为启动项目，点击运行（也可下载安装包运行）：
下面列出部分功能截图(基本来自仓库readme)，详细功能请看仓库实时更新。
3.1. functional architecture
3.2. Dashboard
3.3. shortcut query
3.4. import and export
3.5. Document screenshot
**CHM Documentation **
**Html document **
**Word document **
**Excel document **
**PDF document **
3.6. list of toolboxes
The use of 3 tools was recorded:
** QR code generation **
Try scanning the code.
**Json formatting **
** Convert Chinese characters to Pinyin **
4. end
Finally, give the warehouse address: https://gitee.com/dotnetchina/SmartSQL.
I hope this tool will bring you convenience, and the tool source code will bring you reference.