Extend context menu for migrations

[unopcpavilion]

In my day-to-day work, I often come across tasks that require updating EF Core migrations with the databases I'm working on. Currently, this process requires manual navigation to:

• Tools
• Entity Framework Core
• Update Database
• Selecting the target migration
• Clicking OK

This sequence of actions can sometimes prove cumbersome and time-inefficient. As a solution to this problem and to optimize efficiency, I propose a new feature for the EF Core plugin.

I envision this feature to manifest as a context menu item that becomes available when a developer right-clicks on a migration file. A new option, "Update to this Migration," would then enable the developer to directly update the corresponding database to mirror changes up until the selected migration. As a bonus, this feature could also handle reverting migrations, thereby significantly expanding its potential uses.

Another part of my proposal pertains to distinct color-coding for migration files. Currently, they look like conventional C# files. However, for projects that utilize a single DB context (which I believe make up over 90% of all projects), discerning which migrations have been applied and which have yet to be implemented from the rest of the files would be tremendously convenient. I propose the differentiation of applied and yet-to-be-applied migrations via separate color-coding.

Lastly, an important feature I believe needs to be incorporated is the automatic opening of a created migration post its creation like it done in visual studio.