EFPT: Add Migrations UI

[erikej]

EFPT: Add Migrations UI

[ErikEJ]

@bricelam - I think I can now make GetMigrationStatus and ApplyMigrations work, but how do I create migrations and get them added to the project.

https://github.com/ErikEJ/SqlCeToolbox/blob/master/src/GUI/EFCorePowerTools/Handlers/MigrationsHandler.cs

https://github.com/ErikEJ/SqlCeToolbox/blob/master/src/GUI/ReverseEngineer20/EFCoreModelBuilder.cs#L62

[ErikEJ]

From @bricelam on April 9, 2018 15:31

Scaffold:
https://github.com/aspnet/EntityFrameworkCore/blob/dev/src/EFCore.Design/Design/Internal/MigrationsOperations.cs#L92-L94

Add to project:
https://github.com/aspnet/EntityFrameworkCore/blob/dev/src/EFCore.Tools/tools/EntityFrameworkCore.psm1#L70-L76

[ErikEJ]

UI:
Dropdown with all DbContexts:

1: Add a migration if there are pending model changes. Needs a way to specify the migration name too.

"There are pending model changes, scaffold a migration with the changes."
Name:
Cmd: Scaffold

2: Apply migrations if any aren't applied:
"There are migrations that have not been applied to the database"

Cmd: Apply

3: Everything is up-to-date.
"Your database and model are in sync"
Cmd: OK
(May need a unicorn picture here)

[ErikEJ]

Gif: https://tenor.com/view/unicorn-popsicle-lick-gif-8982067

https://www.nuget.org/packages/WpfAnimatedGif

https://blogs.msdn.microsoft.com/miah/2008/02/28/how-to-assign-a-strong-name-to-an-unsigned-3rd-party-assembly/
WpfAnimatedGifSigned.zip

[ErikEJ]

New icon!

[ErikEJ]

@bricelam Hi Brice, I am ready with a preview of the Migration UI, but have an issue with detecting "Pending changes" - I have implemented this: https://github.com/aspnet/Diagnostics/blob/dev/src/Microsoft.AspNetCore.Diagnostics.EntityFrameworkCore/DatabaseErrorPageMiddleware.cs#L141-L143 - but I get "InSync" from here instead of "HasChanges" after adding a new property to a class.

https://github.com/aspnet/Diagnostics/blob/dev/src/Microsoft.AspNetCore.Diagnostics.EntityFrameworkCore/DatabaseErrorPageMiddleware.cs#L141-L143

(Testing with EF Core 2.0)

[ErikEJ]

@bricelam Never mind!! Error 40 😄