使用 EFCore简单入门(实体类生成数据库表)

1.安装Nuget包

Microsoft.EntityFrameworkCore.SqlServer

Microsoft.EntityFrameworkCore.Tools

2.创建Book,Post两个实体类

public class Book
{
    /// <summary>
    /// id
    /// </summary>
    public int Id { get; set; }
    /// <summary>
    /// 书本名称
    /// </summary>
    public string Name { get; set; }
    /// <summary>
    /// 价格
    /// </summary>
    public int Price { get; set; }
    /// <summary>
    /// 所属类型
    /// </summary>
    public string Type { get; set; }
}

public class Post
{
    /// <summary>
    /// 借书人
    /// </summary>
    public int PostId { get; set; }
    /// <summary>
    /// 姓名
    /// </summary>
    public string PostName { get; set; }
    /// <summary>
    /// 性别
    /// </summary>
    public string Sex { get; set; }
    /// <summary>
    /// 住址
    /// </summary>
    public string Address { get; set;}
}

3.创建一个xxxx类我这点取名BingBDContext类

public class BingBDContext:DbContext
{
    public DbSet<Book> Books { get; set; }
    public DbSet<Post> Posts { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("server=.;database=NewTable;uid=sa;pwd=123456;TrustServerCertificate=True");
    }
}

4.打开解决方案文件夹,进入cmd运行两个命令

dotnet ef migrations add 自定义一个名字
dotnet ef database update

5. dotnet 需要安装net core 运行时
https://dotnet.microsoft.com/zh-cn/download/dotnet
6. 我这点安装的是 net8,

7. 选择运行时安装,不要安装sdk包
8.安装 

Microsoft.EntityFrameworkCore.SqlServer

Microsoft.EntityFrameworkCore.Tools

时,选择安装的版本要和安装运行时的版本一致,否则: 嘿嘿嘿~你懂的