数据库表结构文档查看器 基于netcore

日常开发业务代码，新接手一块不熟悉的业务时需要频繁的查看对应业务的数据库表设计文档。相比于直接翻看业务代码，有必要提供一个数据库表结构文档查看器来解决这些繁琐的问题。

CML.SqlDoc

CML.SqlDoc 是基于netcore开发的数据库表结构文档查看器，通过简单的配置部署即使用， 数据库表结构文档查看器支持MSSql MySql多数据库

界面呈现

 

　　

如何部署

*appsettings.json 数据库连接以及库名写入配置文件 格式如下

{ "ConnectionStrings": { "SqlDoc.Reader": { "ConnectionString": "Min Pool Size=10;Max Pool Size=500;Connection Timeout=50;Data Source=127.0.0.1;Initial Catalog=Demo;Persist Security Info=True;User ID=sa;Password=123123", "providerName": "System.Data.SqlClient" }, "SqlDoc.Writer": { "ConnectionString": "Min Pool Size=10;Max Pool Size=500;Connection Timeout=50;Data Source=127.0.0.1;Initial Catalog=Demo;Persist Security Info=True;User ID=sa;Password=123123", "providerName": "System.Data.SqlClient" } }, "DataBaseConfig": [ { "Id": "1", "Title": "XX系统", "DbName": "DBName2", "ConnectionString": "Min Pool Size=10;Max Pool Size=500;Connection Timeout=50;Data Source=xxxx;Initial Catalog=xxxx;Persist Security Info=True;User ID=xxxx;Password=xxxxx!", "DbType": "MSSQLServer" }, { "Id": "2", "Title": "YY系统", "DbName": "DbName1", "ConnectionString": "Server=xxxxxx;Port=3306;Database=bt_hyaline;Uid=xxxx;Pwd=xxxxx;Charset=utf8;", "DbType": "MySql" } ] }