EntityFramework Migration Generation Produces Unexpected Index Column

[vsfeedback]

This issue has been moved from a ticket on Developer Community.

---

[severity:It's more difficult to complete my work]
Please see attached SLN. After running the following command in Visual Studio's Developer PowerShell:

dotnet ef migrations add EFCore72 -v --project Starbeam.Applications.Gateway.Initialization --startup-project Starbeam.Entities.Design --configuration Debug

It produces the 20230628141213_EFCore72 file which contains the following command:

migrationBuilder.CreateIndex(
                name: "IX_Transaction_SystemDebit_SourceId",
                table: "Transaction",
                column: "SystemDebit_SourceId",
                unique: true,
                filter: "[SourceId] IS NOT NULL");

Expected:

migrationBuilder.CreateIndex(
                name: "IX_Transaction_SystemDebit_SourceId",
                table: "Transaction",
                column: "SystemDebit_SourceId",
                unique: true,
                filter: "[SystemDebit_SourceId] IS NOT NULL");

---

Original Comments

Feedback Bot on 6/29/2023, 03:24 AM:

(private comment, text removed)

---

Original Solutions

(no solutions)

[ajcvickers]

This issue is lacking enough information for us to be able to fully understand what is happening. Please attach a small, runnable project or post a small, runnable code listing that reproduces what you are seeing so that we can investigate.

[Mike-E-angelo]

Hi @ajcvickers thank you for your reply and investigation. For clarity, this is the same solution you were able to attend to with #29847. I removed the indexes as you suggested and ran the above command, resulting in the generated migration which is a part of the solution as provided in the developercommunity ticket. Please let me know if there is any further information required.

[ajcvickers]

Duplicate of #31153