前言
日常开发业务代码, 新接手一块不熟悉的业务时需要频繁的查看对应业务的数据库表设计文档. 相比于直接翻看业务代码, 有必要提供一个数据库表结构文档查看器来解决这些繁琐的问题.
CML.SqlDoc
CML.SqlDoc 是基于 netcore 开发的数据库表结构文档查看器, 通过简单的配置部署即使用, 数据库表结构文档查看器支持 MSSql MySql 多数据库
https://github.com/willianchen/CML.SqlDoc/blob/master/README.md#界面呈现 界面呈现
如何部署
*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"
- }
- ]
- }
https://github.com/willianchen/CML.SqlDoc/blob/master/README.md#技术栈 技术栈
基于. Net Core 2.1 开发;
后端采用 asp.net mvc core 2.1 + Dapper + autofac
https://github.com/willianchen/CML.SqlDoc/blob/master/README.md#补充 补充
Git 源码: https://github.com/willianchen/CML.SqlDoc
项目引用 CML.Lib CML.DataAccess 两个包已发布至 nuget, 源码请见 [git] https://github.com/willianchen/CML.NetCore
Sqlserver 表注释 sql 语句
-- 表加注释
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'注释内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'表名'
-- 例如:
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统设置表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CM01_SYSTEM'
-- 字段加注释
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'注释内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'表名', @level2type=N'COLUMN',@level2name=N'字段名'
有问题反馈
在使用中有任何问题, 欢迎反馈给我, 可以用以下联系方式跟我交流
邮件 (willianli#126.com, 把 #换成 @)
QQ: 474852546
来源: https://www.cnblogs.com/chenminli/p/9174229.html