Map entity to lookup table with composite foreign key that is partially hard-coded

Using EF Core 3.1.2 database-first, we have a model like below. This is an inherited database, and changing the schema is not preferred. We also have a team decision to prefer data annotations rather than fluent.

We have many different tables that have related rows in ReferenceDictionary. The relationship between these tables and ReferenceDictionary is defined by the composite key (ReferenceDictionary.Category, ReferenceDictionary.Id). The Category value is always the same for any given row in the same related table.

For example, all instances of FooEntity from FooTable use a value of 'FooCategory' for ReferenceDictionary.Category. Likewise, all instances of BarEntity from BarTable use a value of 'BarCategory' for ReferenceDictionary.Category.

The Category for ReferenceDictionary is not actually stored anywhere in FooTable or BarTable, however (there are no database columns FooEntity.ReferenceDictionaryCategory or BarEntity.ReferenceDictionaryCategory).

I tried the solution below using the [NotMapped] attribute to configure this relationship, but I get an error that FooEntity.ReferenceDictionaryCategory is not a column in the database (which it isn't).

Question:

How can I configure the EF relationships so that the navigational property FooEntity.ReferenceDictionary successfully maps to an instance of ReferenceDictionary using the following composite key mapping?

• ReferenceDictionary.Category = 'FooCategory'
• ReferenceDictionary.Id = FooEntity.ReferenceDictionaryId

Current Code:

public class ReferenceDictionary
{
    [PrimaryKey(Order = 1)]
    public string Category { get; set; }

    [PrimaryKey(Order = 2)]
    public int Id { get; set; }

    ...
}

public class FooEntity
{
    [Key]        
    public int Id { get; set; }

    [NotMapped]
    public string ReferenceDictionaryCategory { get; } = "FooCategory";

    public int ReferenceDictionaryId { get; set; }

    [ForeignKey(nameof(ReferenceDictionaryCategory) + ", " + nameof(ReferenceDictionaryId))]
    public virtual ReferenceDictionary ReferenceDictionary { get; set; }

    ...
}

public class BarEntity
{
    [Key]        
    public int Id { get; set; }

    [NotMapped]
    public string ReferenceDictionaryCategory { get; } = "BarCategory";

    public int ReferenceDictionaryId { get; set; }

    [ForeignKey(nameof(ReferenceDictionaryCategory) + ", " + nameof(ReferenceDictionaryId))]
    public virtual ReferenceDictionary ReferenceDictionary { get; set; }

    ...
}