EntityTypeBuilder.HasIndex HasIndex improvement

[mrpmorris]

I needed to have more than one index on a property, but adding the second index replaced the first. I was told how to achieve this, by using a 2nd name argument, but if you don't already know what it does then it is not clear what it is for.

Current text

Configures an index on the specified properties and with the given name. If there is an existing index on the given list of properties and with the given name, then the existing index will be returned for configuration. This feature allows for the

Recommended

Configures an index on the specified properties and with the given name. If there is an existing index on the given list of properties and with the given name, then the existing index will be returned for configuration. This allows the definition of multiple different indexes on the same property, that can be identified by name.

Is there a more complete documentation on this somewhere? I was unable to find any MS docs at all explaining how to create multiple indexes on a single property (I have different filters on them). The only doc I found was this one which talks about only allowing a single index -

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: e5849407-fc78-90a9-56ad-099df52e7484
• Version Independent ID: 573de756-717a-e546-a153-be1a41f8e3cb
• Content: EntityTypeBuilder.HasIndex Method (Microsoft.EntityFrameworkCore.Metadata.Builders)
• Content Source: dotnet/xml/Microsoft.EntityFrameworkCore.Metadata.Builders/EntityTypeBuilder.xml
• Product: ef-core-api
• GitHub Login: @dotnet-bot
• Microsoft Alias: avickers

[roji]

Duplicate of #4582