Entity Framework Multiple Column as Primary Key by Fluent Api

Question

These are my simplified domain classes.

public class ProductCategory
{
    public int ProductId { get; set; }
    public int CategoryId { get; set; }

    public virtual Product Product { get; set; }
    public virtual Category Category { get; set; }
}

public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
} 

public class Category
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int? ParentCategoryId { get; set;} 
}

This is my mapping class. But it doesn't work.

public class ProductCategoryMap : EntityTypeConfiguration<ProductCategory>
{
    public ProductCategoryMap()
    {
        ToTable("ProductCategory");
        HasKey(pc => pc.ProductId);
        HasKey(pc => pc.CategoryId);
    }
}

How should I map these classes to provide, so that one product can be seen in multiple categories?

Grigory Zhadko · Accepted Answer · 2021-03-31 03:49:37Z

163

Use anonymous type object instead of 2 separated statements:

HasKey(pc => new { pc.ProductId, pc.CategoryId });

From Microsoft Docs: EntityTypeConfiguration.HasKey Method

If the primary key is made up of multiple properties then specify an anonymous type including the properties. For example, in C# t => new { t.Id1, t.Id2 } and in Visual Basic .Net Function(t) New With { t.Id1, t.Id2 }.

edited Mar 31, 2021 at 3:49

Grigory Zhadko

1,8841 gold badge28 silver badges39 bronze badges

answered Mar 16, 2013 at 21:04

MarcinJuraszek

126k15 gold badges200 silver badges267 bronze badges

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

3 Comments

Alicia Over a year ago

For me, in VB.NET, it was Function(t) With { t.Id1, t.id2 } that did the trick (rather than "From").

zolty13 Over a year ago

Is it possible to convert non-primitive value object containing two fields? : public class MyId { public int CompanyId; public int UserId }

ilyas varol Over a year ago

Thanks to you, I learned this usage. Before I searched a lot time but I got nothing about this. By the way, is it called AlternateKey as well?

Collectives™ on Stack Overflow

Entity Framework Multiple Column as Primary Key by Fluent Api

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related