EF Core To MySQL

1. install packages from nuget

 

 

2. crate dbcontext  and model

    public class IDSContext : DbContext
    {
        public IDSContext(DbContextOptions<IDSContext> options) : base(options)
        {
        }

        public DbSet<User> Users { set; get; }
    }

3. add to service collection

  public void ConfigureServices(IServiceCollection services)
        {

            var connMysqlStr = Configuration.GetConnectionString("DefaultConnection");

            services.AddDbContext<IDSContext>(builder => builder.UseMySQL(connMysqlStr));

            services.AddControllers();
            services.AddSwaggerGen(c =>
            {
                c.SwaggerDoc("v1", new OpenApiInfo { Title = "EfCore_Demo", Version = "v1" });
            });
        }

4. migration database by package manager console

　　①Add-Migration A

　　②Update-Database

5.check database