1、引用組件

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

2、設(shè)置連接數(shù)據(jù)庫字符串

配置 appsettings.json，添加 “ConnectionStrings"

{
  "ConnectionStrings": {
    "book": "Data Source=localhost;Initial Catalog=wlw1902ABook;Persist Security Info=True;User ID=sa;Password=sa1234"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*"
}

3、創(chuàng)建Model

3.1 BookType （圖書分類）

[Table("BookType")]
public class BookType
{
    [Key]
    public int TypeId { get; set; }

    [Required]
    [MaxLength(30)]
    public string TypeName { get; set; }
}

3.2 Book （圖書信息）

    [Table("Book")]
    public class Book
    {
        [Key]
        public int BookId { get; set; }

        [Required]
        [MaxLength(30)]
        public string BookName { get; set; }

        [Required]
        public decimal Price { get; set; }

        [Required]
        [MaxLength(20)]
        public string Author { get; set; }

        [Required]
        public DateTime PublishedDate { get; set; }

        [Required]
        public int TypeId { get; set; }

        [ForeignKey("TypeId")]
        public virtual BookType BookType { get; set; }
    }

4、創(chuàng)建數(shù)據(jù)上下文

public class BookDbContext : DbContext
{
    // 構(gòu)造函數(shù)（構(gòu)造方法）
    public BookDbContext(DbContextOptions<BookDbContext> options) : base(options)
    {
    }

    // 映射（生成數(shù)據(jù)庫中的表）
    public DbSet<BookType> BookTypeSet { get; set; }
    public DbSet<Book> BookSet { get; set; }
}

5、StartUp中配置數(shù)據(jù)上下文

public void ConfigureServices(IServiceCollection services)
{
    services.AddControllersWithViews();

    // 配置數(shù)據(jù)庫上下文
    // 數(shù)據(jù)庫連接字符串
    string strConn = Configuration.GetConnectionString("book");
    services.AddDbContext<BookDbContext>(options => options.UseSqlServer(strConn));
}

6、數(shù)據(jù)遷移

6.1、 add-migration 備份名稱 firstCreateBookInfo

6.2、update-database

7、使用EF