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