I have built a ASP.NET Core MVC application that connects to MySQL. I wanted to enhance the solution by adding Entity Framework because it automatically generates entities and models for you. But reading about this new version (EF Core), it looks like you have to create the models in code then run a script to create the database. That seems backwards, what is the benefit if you don't want to create the database at runtime?
I thought Entity Framework was the opposite, you could create the database first, then add connect it in Visual Studio through a nice UI and it would generate everything for you. Why is it reversed now? I would rather maintain the database in MySQL, then fetch / sync the changes in Visual Studio.
It is true that Entity Framework Core (for now, at least) only supports the Code First approach, but that only means that the option to generate classes through EDMX files and T4 (normally using the visual designer) is gone.
You have two options for Code First, just as you do in Entity Framework 6:
Both options will leave you tied only to your POCOs and you can decide whether you want to use migrations or not.