MapEnum interferes with previous ConfigureDataSource call #3478

using System.ComponentModel.DataAnnotations;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Migrations;
using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;

public class TestEntity {
  [Key]
  public int Id { get; set; }
  public required string First { get; set; }
  public required string Second { get; set; }
}

public class AppDbContext(
    DbContextOptions<AppDbContext> options) : DbContext(options) {
  public required DbSet<TestEntity> TestEntities { get; set; }
}

[DbContext(typeof(AppDbContext))]
[Migration("00_InitialSchema")]
public class InitialSchema : Migration {
  protected override void Up(MigrationBuilder migrationBuilder) {
    migrationBuilder.AlterDatabase()
      .Annotation("Npgsql:Enum:public.test_enum", "value_one,value_two");

    migrationBuilder.CreateTable(
      name: "TestEntities",
      columns: table => new {
        Id = table.Column<int>(type: "integer", nullable: false)
          .Annotation("Npgsql:ValueGenerationStrategy",
            NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
        First = table.Column<string>(type: "text", nullable: false),
        Second = table.Column<string>(type: "text", nullable: false)
      },
      constraints: table => {
        table.PrimaryKey("PK_TestEntities", x => x.Id);
      });
  }
}

public enum TestEnum {
  ValueOne,
  ValueTwo,
}

public class Program {
  public static void Main(string[] args) {
    var builder = WebApplication.CreateBuilder(args);
    builder.Services
      .AddDbContextPool<AppDbContext>(
        static (provider, builder) => builder
          .UseNpgsql(
            "Server=127.0.0.1;User Id=cosmic;Password=password;Database=postgres",
            static opt => opt
              .ConfigureDataSource(static ds => ds
                .EnableRecordsAsTuples())
              // commenting out the following line or moving it
              // before the ConfigureDataSource call fixes it
              .MapEnum<TestEnum>("test_enum", "public", null)
        ));
    var app = builder.Build();
    using var scope = app.Services.CreateScope();
    using var db = scope.ServiceProvider.GetRequiredService<AppDbContext>();
    db.Database.Migrate();

    var newRow = new TestEntity {
      First = "foo",
      Second = "bar",
    };

    db.TestEntities.Add(newRow);
    db.SaveChanges();

    var tuple = db.Database.SqlQueryRaw<(string, string)>(@"
      select row(""First"", ""Second"") as ""Value""
      from ""TestEntities""").ToList();
  }
}