Work around for UseIdentityColumn?

[drewdelano]

It looks like there's a bug in EF that prevents it from recognizing strongly typed IDs (longs / int64) as potential identity columns.

Identity value generation cannot be used for the property 'Id' on entity type 'MyTask' because the property type is 'TaskId'. Identity value generation can only be used with signed integer properties.

Has anyone found a way to avoid this? I'd put this in the EF Core repo, but I'm guessing it wouldn't be prioritized.

[drewdelano]

This seemed to work for me: https://github.com/SpatialFocus/EFIdentityColumnWithValueConverterWorkaround

[MovGP0]

Is there also a version of that workaround for SQL Server?

[MovGP0]

The following does not work :-(

        modelBuilder.Entity<Customer>(entity =>
        {
            entity.ToTable("Customer", "dbo");
            entity.HasKey(e => e.Id);

            entity.Property(e => e.Id)
                .HasColumnName("Id")
                .HasColumnType("bigint")
                .HasConversion<CustomerId.EfCoreValueConverter>()
                .ValueGeneratedOnAdd();

            // ...
        });