# woniu-dotnet

**Repository Path**: pangshw/woniu-dotnet

## Basic Information

- **Project Name**: woniu-dotnet
- **Description**: .net 6，entity framework core
- **Primary Language**: C#
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-06-13
- **Last Updated**: 2023-06-13

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# woniu-dotnet

#### 介绍
spring boot、spring cloud、mybatis

#### 生成实体类
Scaffold-DbContext -Connection "server=xxx; database=woniu-dev; uid=root; pwd=xxx;" -Provider Pomelo.EntityFrameworkCore.MySql -OutputDir Models -Tables "sys_user" -DataAnnotations


#### 数据库初始化
```
CREATE TABLE `sys_user` (
	`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
	`user_name` VARCHAR(50) NULL DEFAULT NULL COMMENT '用户名' COLLATE 'utf8mb4_0900_ai_ci',
	`nick_name` VARCHAR(50) NULL DEFAULT NULL COMMENT '昵称' COLLATE 'utf8mb4_0900_ai_ci',
	`password` VARCHAR(50) NULL DEFAULT NULL COMMENT '密码' COLLATE 'utf8mb4_0900_ai_ci',
	`name` VARCHAR(50) NULL DEFAULT NULL COMMENT '姓名' COLLATE 'utf8mb4_0900_ai_ci',
	`create_time` DATETIME NULL DEFAULT NULL COMMENT '创建时间',
	`update_time` DATETIME NULL DEFAULT NULL COMMENT '修改时间',
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `user_name` (`user_name`) USING BTREE
)
COMMENT='用户表'
COLLATE='utf8mb4_0900_ai_ci'
ENGINE=InnoDB
;
```
#### 0.1 说明
appsettings.json修改默认连接字符串

Program.cs初始化ApplicationDbContext需要指定MySql版本号