首先添加引用

$ dotnet add package Microsoft.EntityFrameworkCore
$ dotnet add package Microsoft.EntityFrameworkCore.SqlServer
# 下面这个主要做数据迁移时必须添加
$ dotnet add package Microsoft.EntityFrameworkCore.Design

创建业务类 Student.cs

using System;

namespace efcoredemo1
{
    public class Student
    {
        public int Id { get; set; }
        public int Age { get; set; }
        public byte Status { get; set; }
        public string Name { get; set; }
        public DateTime CreatedTime { get; set; }
    }
}

创建数据库上下文 EFCoreDbContext.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Text;

namespace efcoredemo1
{
    public class EFCoreDbContext:DbContext
    {
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            string connectionString =
                "Data Source=192.168.10.1,1433;Integrated Security=false;Initial Catalog=db2;User Id = user1;Password = userpassword1;";
            
            optionsBuilder.UseSqlServer(connectionString);
        }
        
        public DbSet<Student> Students { get; set; }
    }
}

将当前工作目录设置为项目目录，输入如下命令

$ dotnet ef migrations add DbInit -c EFCoreDbContext -o Data/Migrations
$ dotnet ef database update -c EFCoreDbContext

数据库及相关库表创建完成