EFCore模型驱动+Mysql

1、建立Web.Models类库并通过NuGet安装EFCore需要包

    MySql.EntityFrameworkCore 7.0.5

    Microsoft.EntityFrameworkCore.Tools 7.0.5

    Microsoft.EntityFrameworkCore.Design 7.0.5

注意版本最好一致，我安装的时候，MySql.EntityFrameworkCore 版本低，运行报错了。

2、建立实体类 Book.cs

 

namespace Web.Models
{
    public class Book
    {
        public long Id { get; set; }    
        public string Title { get; set; }
        public DateTime PubTime { get; set; }
        public double Price { get; set; }
        public string AuthorName { get; set; }
    }
}

3、对Book类进行属性配置

namespace Web.Models
{
    internal class BookEntityConfig:IEntityTypeConfiguration<Book>
    {
        public void Configure(EntityTypeBuilder<Book> builder) 
        {
            builder.ToTable("T_Books");
            builder.Property(e => e.Title).HasMaxLength(50).IsRequired();
            builder.Property(e=>e.AuthorName).HasMaxLength(20).IsRequired();
        }   
    }
}

4、建立可操作的ORM

namespace Web.Models
{
    public class TestDbContext : DbContext
    {
        public DbSet<Book> Books { get; set; }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            string connStr = "server=localhost;port=3306;database=virtual_medicine;user=root;pwd=qwe123;charset=utf8;";
            optionsBuilder.UseMySQL(connStr);
        }
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);
            modelBuilder.ApplyConfigurationsFromAssembly(this.GetType().Assembly);
        }
    }
}

5、NuGet控制台创建表

PM> Add-Migration InitialCreate
Build started...
Build succeeded.
To undo this action, use Remove-Migration.

 

PM> Update-database
Build started...
Build succeeded.
Applying migration '20230807102353_InitialCreate'.
Done.

注：红色背景为输入命令，后面的为执行后控制台打印出来的命令。

 6、修改Mysql编码格式（主要解决插入中文报错问题）

输入 show variables like 'character%' 查看数据库的编码为latin1

     

数据命令 ALTER DATABASE `table` CHARACTER SET utf8 将数据库编码格式改为utf8

注意：如果建表的时候没有改，删除重新建立才生效。

7、执行控制器代码像表中插入数据

 using TestDbContext ctx = new TestDbContext();
            var b1 = new Book { AuthorName = "吴军", Title = "编程之美", Price = 59.8, PubTime = new DateTime(2019, 3, 1) };
            var b2 = new Book { AuthorName = "FrederickP.Brooks.Jr.", Title = "人月神话", Price = 112, PubTime = new DateTime(2020, 5, 1) };

            ctx.Books.Add(b1);
            ctx.Books.Add(b2);

            ctx.SaveChanges();

 

参考地址：https://blog.csdn.net/seven0000000007/article/details/130401692

                  https://blog.csdn.net/AlinaQ05/article/details/126102699