Hi I was working in an environment where we would update the database script for database schema or read-only data in the script, or would use the SQL Project to create the script so that script can be given to update the database in production or to anyone who needs the latest update.
Now for my own little project I started to use the EF Core, which takes the database first approach. And I have questions.
1) Once the release is done how I can provide the changes to the production.
2) If there are tables whose sole purpose is read only, what would be the best way to create insert statement or updated statement if something changes in the table. For example a Table Department. This department does not get updated commonly and mostly use for read only.