Dotnet 7 RC1 SQLPersistence Issues

[nickbeau]

During Elsa Migrations, using dotnet 7 RC1 and EF Core 7 RC1, the following error is presented:

Applying migration '20210523093504_Initial'. Unhandled exception. System.MissingMethodException: Method not found: 'Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder1<Microsoft.EntityFrameworkCore.Migrations.Operations.CreateIndexOperation> Microsoft.EntityFrameworkCore.Migrations.MigrationBuilder.CreateIndex(System.String, System.String, System.String, System.String, Boolean, System.String)'. at Elsa.Persistence.EntityFramework.SqlServer.Migrations.Initial.Up(MigrationBuilder migrationBuilder) at Microsoft.EntityFrameworkCore.Migrations.Migration.BuildOperations(Action1 buildAction) at Microsoft.EntityFrameworkCore.Migrations.Migration.get_UpOperations() at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.GenerateUpSql(Migration migration, MigrationsSqlGenerationOptions options) at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.<>c__DisplayClass16_2.<GetMigrationCommandLists>b__2() at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.MigrateAsync(String targetMigration, CancellationToken cancellationToken) at Elsa.Persistence.EntityFramework.Core.StartupTasks.RunMigrations.ExecuteAsync(CancellationToken cancellationToken) at Elsa.Persistence.EntityFramework.Core.StartupTasks.RunMigrations.ExecuteAsync(CancellationToken cancellationToken) at Elsa.Runtime.StartupRunner.StartupAsync(CancellationToken cancellationToken) at Elsa.HostedServices.StartupRunnerHostedService.StartAsync(CancellationToken cancellationToken) at Microsoft.Extensions.Hosting.Internal.Host.StartAsync(CancellationToken cancellationToken) at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token) at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token) at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.Run(IHost host)

[Chryssie]

It looks like that method as a new parameter in EFCore 7 to specify the sort-order (see here: https://github.com/dotnet/efcore/blob/786798e80b518f1af450152359c081d1d7c93d59/src/EFCore.Relational/Migrations/MigrationBuilder.cs). Rebuilding against EFCore 7 should resolve this issue as that should only break backwards compatibility at a binary level.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.