（3）建立上下文对象并使用SqlSugar生成实体类

上一篇：（2）CM.Api项目创建Json包装类与数据库操作接口

• 右键解决方案，新建解决方案文件夹，取名为工具
  
• 在工具文件夹下继续新建控制台项目ModelClassBuilder
  
  
  
• 右键管理安装NuGet程序包，安装 SqlSugar， 中途会有两个弹框（忘记截图了）依次选择“确定”、“我接受”
  
  点击安装
  
• 在 ModelClassBuilder下添加类DbContext
  
  
• 先退出 Microsoft Visual Studio, 如下图所示，我用的是navicat数据库管理工具，建立一个新的连接，信息如下（密码是root），然后建立名为 dotnetcms 的数据库，运行dotnetcms.sql :链接: https://pan.baidu.com/s/1UovG79Ubbnc4JwmCH_93aw 提取码: sw77
  
  dotnetcms.sql 文件代码：

/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50729
 Source Host           : 127.0.0.1:3306
 Source Schema         : dotnetcms

 Target Server Type    : MySQL
 Target Server Version : 50729
 File Encoding         : 65001

 Date: 10/05/2020 16:39:34
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cm_api
-- ----------------------------
DROP TABLE IF EXISTS `cm_api`;
CREATE TABLE `cm_api`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接口名称',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '#' COMMENT '接口断点',
  `methods` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '00000' COMMENT '可调方法',
  `orderNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '\'99\'' COMMENT '同级排序号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cm_api
-- ----------------------------

-- ----------------------------
-- Table structure for cm_article
-- ----------------------------
DROP TABLE IF EXISTS `cm_article`;
CREATE TABLE `cm_article`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章标题',
  `columnId` bigint(20) NOT NULL COMMENT '所属栏目',
  `body` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容文本',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章链接',
  `fileUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件网址',
  `bigPic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '大图网址',
  `smallPic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NUL