EF Core ValueGeneratedOnAdd does not work with postgresql

Question

When using ConfigurationDbContext from Assembly IdentityServer4.EntityFramework.Storage

And seeding database with IdentityServer4.Models.Client entity

I get the following error: PostgresException: 23502: null value in column "Id" violates not-null constraint

I took a look at the database and it turns out that the column is of type integer, even though I'd expect it to be serial.

Below you can see parts of migration code responsible for column creation:

 migrationBuilder.CreateTable(
                name: "Clients",
                columns: table => new
                {
                    Id = table.Column<int>(nullable: false)
                        .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),

and

modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.Client", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

Basing on documentation https://www.npgsql.org/efcore/value-generation.html, calling ValueGeneratedOnAdd() on a integer column should result in serial type in the database.

Any thoughs on this?

Answer 1

Changing

.Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn)

to

.Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.SerialColumn)

has solved the problem.