Entity Framework Fluent API - Map Property to Specific Table

Question

I would like to create internal mapping of navigation property to specific table using EF's fluent API.

Meaning - Same type is mapped to different tables according to parent type

(see code below) Thank you!

public record Entity1
{
   public long Id { get; set;}
   public IEnumerable<Identifier> Ids { get; set; } //Map to map to table 'Entity1_Ids'
}

public record Entity2
{
   public long Id { get; set;}
   public Identifier Ids { get; set; } //Map to map to table 'Entity2_Ids'
}

public record Identifier
{
   public long Id { get; set;}
   public string? Type { get; set; }
   public string? Value { get; set; }
}

David Browne - Microsoft · Accepted Answer · 2023-02-28 17:26:47Z

0

You can do this with Owned Entity Types.

eg

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    base.OnModelCreating(modelBuilder);

    modelBuilder.Entity<Entity1>().OwnsMany(e => e.Ids).ToTable("Entity1_Ids");
    modelBuilder.Entity<Entity2>().OwnsOne(e => e.Ids).ToTable("Entity2_Ids");

}

answered Feb 28, 2023 at 17:26

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework Fluent API - Map Property to Specific Table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related