Multiple Index on same property?

[ziaulhasanhamim]

I wanted to create two indexes on the same property. Like one GIN and the other one normal. But EF only generates sql for one index.
I found this issue on efcore repo. But didn't help. Because PostgreSQL supports multiple indexes on the same property. So why can't generate SQL for that?

builder.Entity<Customer>()
            .HasIndex(c => c.Name)
            .HasDatabaseName("IX_Customers_Name");

builder.Entity<Customer>()
            .HasIndex(c => c.Name)
            .HasMethod("GIN")
            .HasOperators("gin_trgm_ops")
            .HasDatabaseName("IX_Customers_Name_GIN");

Is it something I'm doing wrong here? I need both of these indexes. Because GIN helps a lot when running LIKE or ILIKE query(My applicated uses LIKE heavily) and also needs a normal index for the equal query.

[roji]

EF can definitely generate this, but you need to define the name inside HasIndex, and not via HasDatabaseName:

builder.Entity<Customer>()
            .HasIndex(c => c.Name, "IX_Customers_Namer");

builder.Entity<Customer>()
            .HasIndex(c => c.Name, "IX_Customers_Name_GIN")
            .HasMethod("GIN")
            .HasOperators("gin_trgm_ops");

Let me know if that works for you. I've opened dotnet/EntityFramework.Docs#4081 to add this to the EF docs

[ziaulhasanhamim]

It works like charm. Thanks

[prcdpr]

I think this overload of HasIndex is unavailable when using OwnedNavigationBuilder. What are alternatives here?

[roji]

@prcdpr can you please open an issue for this on the EF Core repo?

In the meantime, you can always create indexes via SQL in your migrations.