.NET5 SqlSugar 创建数据库表_sqlsugar建表

SqlSugar是一款 老牌 .NET 开源ORM框架，.NET中唯一支持自动分表大数据处理的ORM。官网：https://www.donet5.com/Home/Doc

1、添加SqlSugarCore的NuGet包

2、建立实体

新建数据库实体，这里以用户表为例：

public class Users
{
    /// <summary>
    /// ID
    /// </summary>
    [SugarColumn(IsIdentity = true, IsPrimaryKey = true)]//是否为主键，是否自增
    public int Id { get; set; }
    /// <summary>
    /// 用户名
    /// </summary>
    [SugarColumn(ColumnDataType = "varchar(64)")]//对于字符型字段，要指定数据类型
    public string UserName { get; set; }
    /// <summary>
    /// 昵称
    /// </summary>
    [SugarColumn(ColumnDataType = "varchar(128)")]
    public string NickName { get; set; }
    /// <summary>
    /// 手机号
    /// </summary>
    [SugarColumn(ColumnDataType = "varchar(32)")]
    public string Phone { get; set; }
    /// <summary>
    /// 邮箱
    /// </summary>
    [SugarColumn(ColumnDataType = "varchar(64)")]
    public string Email { get; set; }
    /// <summary>
    /// OpenId
    /// </summary>
    [SugarColumn(ColumnDataType = "varchar(32)")]
    public string OpenId { get; set; }
    /// <summary>
    /// 数据提交时间
    /// </summary>
    [SugarColumn(IsOnlyIgnoreUpdate = true)]//在Update的时候忽略该字段
    public DateTime PostTime { get; set; } = DateTime.Now;
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

3、注入SqlSugar

在appsettings.json中：配置连接字符串

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*",
  "SqlConn": "server=127.0.0.1;port=3306;user=YourUserName;password=YourPassword;database=YourDataBase;"
}
1
2
3
4
5
6
7
8
9
10
11

在Startup.cs类中：

 public void ConfigureServices(IServiceCollection services)
 {
     services.AddControllersWithViews();
     #region SqlSugarIOC
         services.AddSqlSugar(new IocConfig()
		 {
				 ConnectionString = this.Configuration["SqlConn"],
				 DbType = IocDbType.MySql,
				 IsAutoCloseConnection = true,
		 });
     #endregion
 }
1
2
3
4
5
6
7
8
9
10
11
12

4、创建表

/// <summary>
/// 创建数据库表
/// </summary>
public void CreateTable()
{
    // 创建数据库
    base.Context.DbMaintenance.CreateDatabase();
    // 创建表
    base.Context.CodeFirst.InitTables(
        //创建的四个表
        typeof(Models.Users),
        typeof(Models.SearchEngines),
        typeof(Models.SearchLogs),
        typeof(Models.UrlTags)
    );
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

来源：https://www.blackvon.cn/#/detail?id=125&uid=1