Get pending migrations using .NET Core CLI

[PavelStefanov]

Hello guys!

First of all, thank you so much for so great tool.

My question is can I get pending migrations using .NET CLI?

In code I can use method DbMigrator.GetPendingMigrations
Example:

var migrations = dbContext.Database.GetPendingMigrations(); 
if (migrations.Any())
    db.Database.Migrate();

But I can't find the same method in the CLI.
My case is simple I need during my CI pipeline check if there are any pending migration I'll create executable bundle and publish it. Otherwise, I can always create a bundle and try to update my db. But I need more controls about changes and I need to understand if there are any migrations or not.

Thanks!

[ajcvickers]

Note for triage: related to #26348.

[PavelStefanov]

I found workaround. You can use migration list command with --json parameter.

dotnet ef migrations list --json

It gives you structed list of migrations with applied property. You can use it to find pending migrations

[  
  {
    "id": "20220420211839_migration1",
    "name": "migration1",
    "safeName": "migration1",
    "applied": true
  },
  {
    "id": "20220621122349_migration2",
    "name": "migration2",
    "safeName": "migration2",
    "applied": false
  }
]