Scaffold operation doesn't add default value for not nullable property

[sciutand]

Since migrating to dotnet10 and <PackageVersion Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="10.0.0"/>
running

dotnet ef dbcontext scaffold  "Name=DB:ConnectionString" Npgsql.EntityFrameworkCore.PostgreSQL

Causes the generate DBCtx to not have default value for columns that are not nullable and have a default value:

eg:

Found column with table: prod_ui.projects, column name: framework_id, data type: integer, nullable: False, identity: False, default value: 0, computed value: (null)

used to yield:

 entity.Property(e => e.FrameworkId)
                .HasDefaultValue(0)
                .HasColumnName("framework_id");

since the update it yields:

entity.Property(e => e.FrameworkId).HasColumnName("framework_id");

This is obviously a big issue for us as we are no longer able to update our context.

[roji]

I cannot reproduce this - but then you haven't actually included the schema of the table you're scaffolding, so it's impossible for me to see exactly what you're doing. When submitting an issue, please always submit a minimal, runnable repro, which in this case means including a minimal table, which when scaffolded, shows the problem.

I tried reproducing this by creating a table as follows:

CREATE TABLE "Blogs" (
    id INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
    foo INT DEFAULT 0);

I then scaffolded it with EF, and got the following:

entity.Property(e => e.Foo)
    .HasDefaultValue(0)
    .HasColumnName("foo");