.NET5控制台程序使用EF连接MYSQL数据库的方法

1.使用nuget下载：.

Microsoft.Extensions.Configuration.Json

Pomelo.EntityFrameworkCore.MySql

 

2:创建实体类: 

GirlInfo

    public class GirlInfo
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        [Column("id")]
        public int id { get; set; }
        
        [Column("title")]
        public string Name { get; set; }
        [Column("src")]
        public string Src { get; set; }


    }

 

 

3:配置连接信息:

 public class EFCoreContext : DbContext
    {
       
        private string ConnectionString = "Server=localhost;Database=girl2;charset=utf8;uid=root;pwd=root;";
        public EFCoreContext()
        {
               
        }
        public EFCoreContext(string connet)
        {
            DBConnectStr = connet;
        }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {

            optionsBuilder.UseMySql(ConnectionString,         ServerVersion.AutoDetect(ConnectionString), null);
        }
        public DbSet<GirlInfo> girlInfo { set; get; }
    }

4:使用ef的框架生成数据表:

add-migration q

update-database

5:大功告成.