This blog post is not aimed at writing yet another article about a change in the conceptual approach of database definition. And I won’t discuss the advantages of each technique. This blog post is a link collection to IMHO valuable posts and other references.
The following article discusses the different approaches to creating the database and the Entity Framework Core context and model classes.
The following article describes the migration to EF Core with database migrations and the required adjustments to the existing (production) database.
For completeness an article about database migrations. The interesting part for projects with a database (and SQL) first approach, they still can get SQL scripts, even for the delta between database migrations. This is described at the end of the article.