Reference Foreign Key with 3 Foreign Key But 1 Table

Guest User

public class Category
{
public Guid Id { get; set; }
public string Name { get; set; }
}
public class Product
{
public Guid Id { get; set; }
public Guid CategoryId2 { get; set; }
public Guid CategoryId3 { get; set; }
public string Code { get; set; }
public string Name { get; set; }
[ForeignKey("Category")]
public Guid CategoryId1 { get; set; }
public virtual Category Category { get; set; }
}

I have these 2 tables. The Product has 3 foreign key which I need to connect in Category. I only sure about the CategoryId1 but I dont know what to do in CategoryId2 and CategoryId3. what should I do?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User6y ago
Hi Laxmidhar,

Do I need to 2 more tables for Category with the same content?

Category1 and Category2?
0
Laxmidhar Sahoo6y ago
When a table has 3 forgein key that means it connected with three tables .But you display only one tabe which is connected
0
Guest User6y ago
Tables shown below

0
Guest User6y ago
what is the purpose of ParentID?

my entity should be like this?
public class Category
{
public int Id { get; set; }
Public int ParentId { get; set; }
public string Name { get; set; }
}
public class Product
{
public int Id { get; set; }
public int CategoryId2 { get; set; }
public int CategoryId3 { get; set; }
public string Code { get; set; }
public string Name { get; set; }
[ForeignKey("Category")]
public int CategoryId1 { get; set; }
public virtual Category Category { get; set; }
}
0
Madan Shekar6y ago
hey Gaius,

please change your database schema like bellow

Category table :-
Id ParentID Name
1 0 Electronics
2 1 Mobile
3 1 washingmachine

Product table
ID Productname CategoryID
1 apple 2

this will be the effective design
0