I was wondering... since there is no EDMX in EF Core, what is the difference between those 2? And if the major difference would be the possibility to change the database tables, why not use code first then use EF code-first migrations?
DB-First is that you reverse engineer an existing database to create an Entity Framework model.Instead of designing the EDMX manually and generating the SQL script to create the Database, we build the latter and then generate the former using the Entity Framework Designer tool.
Code-First uses migrations to create the database from the data model you define.
However, as long as weâ€™re dealing with a rather small project â€“ for example, a microservice â€“ and/or weâ€™re aiming for a flexible, mutable small-scale data structure, adopting the Code-First approach will almost always be a good choice.