dotnet EF Code First 数据库同步

DBContext 所需包:

Microsoft.EntityFrameworkCore
Microsoft.EntityFrameworkCore.Design
Microsoft.EntityFrameworkCore.SqlServer
Microsoft.EntityFrameworkCore.Tools

program 所需包:

1	Microsoft.EntityFrameworkCore.Design

1. 写好 DBContext

配置 ConnectionString

配置 DbSet<>

public class DaimuDbContext : DbContext
{
    public readonly string connectionString;

    public DaimuDbContext() : this(null) { }
        
    public DaimuDbContext(string ConnectionString)
    {
        if (ConnectionString == null ||
            ConnectionString.Length == 0)
        {
            //Configuration 
            connectionString = "ConnectionString";
        }
        else
        {
            connectionString = ConnectionString;
        }
    }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        if (optionsBuilder != null)
        {
            optionsBuilder.UseSqlServer(connectionString);
        }
    }

    public DbSet<UserInfo> UserInfo { get; set; }

    public DbSet<OrderInfo> OrderInfo { get; set; }
}

2. 在 Startup 中注入

public void ConfigureServices(IServiceCollection services)
{
    services.AddGrpc();
    services.AddDbContext<DaimuDbContext>();
}

3. 打开 NuGet 命令行 , 并选择 DBContext 文件所在目录

4. 输入命令 , 生成 migration 文件

1	add-migration <<#name#>>

5. 输入命令, 同步到数据库

1	update-database <<#name#>>