Migration Scripts broken using HasData and Postgres Enums

[abarriosMagaya]

We have a table with a couple of fields as PostgreSQL enums.

We use HasData to seed some configuration Data.
When we generated the migration script, the enums used look like this 'allow'::main.security_permission_grant_type end as this Allow.

We are migrating our project to DotNet10, and this is blocking us.
The Postgres Enum is:

CREATE TYPE main.security_permission_grant_type AS ENUM
    ('notset', 'allow', 'deny', 'strict_allow', 'strict_deny');

ALTER TYPE main.security_permission_grant_type
    OWNER TO user001;

The C# Enums is:

namespace Service.Entity
{
	public enum SecurityPermissionGrant
	{
		NotSet,
		Allow,
		Deny,
		StrictAllow,
		StrictDeny
	}
}

We register the enums and PostgreSQL enums.

I created a mini Repo to recreate the Issue EnumsIssues with two branches dot-net-8 and dot-net-10

[roji]

I'm not clear on what the problem is, as you haven't provided many details. Please post a clear description of exactly what's happening when you upgrade to EF 10, and ideally include precise steps (and/or a minimal repro).

[abarriosMagaya]

I created a mini Repo to recreate the Issue EnumsIssues with two branches dot-net-8 and dot-net-10

[brianpursley]

Check this for reference if you haven't already. EF9 has some changes in how enums are mapped:
https://www.npgsql.org/efcore/mapping/enum.html?tabs=with-connection-string%2Cwith-datasource

I think the problem might have to do with how you're fully qualifying the enum name in builder.MapEnum<StatusEnum>("public.status_enum");

Instead of mapping the enum in the NpgsqlDataSourceBuilder, try doing it in the options for UseNpgsql, which lets you specify a schema, like this:

npgsqlOptions.MapEnum<StatusEnum>("status_enum", "public");

So in your example project:

public static class DBExtentesions
  {
      public static IServiceCollection AddDBSettings(this IServiceCollection services, IConfiguration configuration)
      {
      var connectionStr = configuration["EnumIssues:ConnectionString"];

      services.AddSingleton(provider =>
      {
        var builder = new NpgsqlDataSourceBuilder(connectionStr);
        // REMOVE THIS LINE: builder.MapEnum<StatusEnum>("public.status_enum");
        return builder.Build();
      });

      services.AddDbContext<Entities.UnumsContext>((serviceProvider, options) =>
        {
          var dataSource = serviceProvider.GetRequiredService<NpgsqlDataSource>();

          options.UseNpgsql(dataSource, npgsqlOptions =>
          {
            npgsqlOptions.MapEnum<StatusEnum>("status_enum", "public"); // DO THIS INSTEAD
            npgsqlOptions.EnableRetryOnFailure();
          });
        });
      return services;
    } 
    
  }