IncludeProperties is ambiguous between the Microsoft.EntityFrameworkCore.SqlServerIndexBuilderExtensions.IncludeProperties and the Microsoft.EntityFrameworkCore.NpgsqlIndexBuilderExtensions.IncludeProperties

[xrkolovos]

We have issue with the use of IncludeProperties, because in our project we have SqlServer and PostgreSql.

The error

The call is ambiguous between the following methods or properties: 
'Microsoft.EntityFrameworkCore.SqlServerIndexBuilderExtensions.IncludeProperties<TEntity>
(Microsoft.EntityFrameworkCore.Metadata.Builders.IndexBuilder<TEntity>, System.Linq.Expressions.Expression<System.Func<TEntity, object>>)' 
and 
'Microsoft.EntityFrameworkCore.NpgsqlIndexBuilderExtensions.IncludeProperties<TEntity>
(Microsoft.EntityFrameworkCore.Metadata.Builders.IndexBuilder<TEntity>, System.Linq.Expressions.Expression<System.Func<TEntity, object>>)'	

[roji]

Yes, this is a known wrinkle. The workaround is to call the desired method explicitly, not as an extension method.

Instead of:

modelBuilder.Entity<Blog>().HasIndex(f => f.Name).IncludeProperties(f => f.Description);

Use:

NpgsqlIndexBuilderExtensions.IncludeProperties(
    modelBuilder.Entity<Blog>().HasIndex(f => f.Name),
    f => f.Description);

This isn't ideal, but the number of projects using multiple providers that support the same extensions is quite low.

[xrkolovos]

Hello,

This issue is worst in .net5.

There is code using IncludeProperties in autogenerated code in the *Designer.cs file.

You must change the name of this method.

[tdolgyras]

How can we reopen this?

[xrkolovos]

Before it used
.HasAnnotation("SqlServer:Include",..