Mangled migration generated when altering database collation

[donhuvy]

Environment: Microsoft Visual Studio Community 2019 Version 16.8.3 ; .NET 5 version 5.0.101 ; ASP.NET Core Blazor WebAssembly 5, Microsoft SQL Server 2019, Windows 10 x64 version 2004.

Entity Framework Core 5.0.1 , Entity Framework Core Package Mange Console tool 5.0.1

run command

PM> Add-Migration

enter a name

SecondDay

I see error syntax at

migrationBuilder.AlterDatabase(,
                oldCollation: "SQL_Latin1_General_CP1_CI_AS");

[donhuvy]

Solution

Add these text

collation: default

migrationBuilder.AlterDatabase(collation: default,
                oldCollation: "SQL_Latin1_General_CP1_CI_AS");

or better, do nothing (delete this line of Migration).

but need fix it in source code of the tool.

[roji]

@donhuvy I'm reopening this as the patch for 5.0.3 hasn't yet gone in.