Entity Framework codefirst 1 to many relations

Question

using the codefirst approach, I would like to have a CODE_YESNO table where it will have two columns C_CODE(1) and C_DESC(5) both type of string.

then I would like to reference it to my other tables.

for example lets say I have I have USERS and PRODUCTS table

and for USERS table I will have userIsActive (foreign key C_CODE) and for PRODUCTS table I will have productIsOnDiscount (foreign key C_CODE)

I don't want to add or do any modifications on the CODE_YESNO table

so how do I do that with the code first approach?

Please enrich your question with detailed table, it's difficult for users to understand your table. — Ali Bahrami
– Ali Bahrami, Commented Jan 26, 2018 at 14:30
Start by modeling your classes (tables) in c#. Add fields and references between tables as properties to those classes. When you are ready, then you have your code first model. — Risto M
– Risto M, Commented Jan 26, 2018 at 14:44
how do I do that with the code first approach? That's far too broad for a Stack Overflow question. — Gert Arnold
– Gert Arnold, Commented Jan 26, 2018 at 14:50

Steve Greene · Accepted Answer · 2018-01-26 14:47:10Z

2

Personally, I would use a boolean if it is just Yes/No. But more generally you can implement lookup tables easily.

public class YesNo
{
    [Key]
    public string C_CODE { get; set; }
    public string C_DESC { get; set; }
}

Then your classes reference through navigation properties:

public class User
{
    public int UserId { get; set; }
    public string UserName { get; set; }

    public string UserIsActiveCode { get; set; }
    [ForeignKey("UserIsActiveCode")]
    public YesNo UserIsActive { get; set; }
}

public class Product
{
    public int ProductId { get; set; }
    public string ProductName { get; set; }

    public string ProductIsOnDiscountCode { get; set; }
    [ForeignKey("ProductIsOnDiscountCode")]
    public YesNo ProductIsOnDiscount { get; set; }
}

answered Jan 26, 2018 at 14:47

Steve Greene

12.4k2 gold badges36 silver badges56 bronze badges

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

1 Comment

Asım Gündüz Over a year ago

a lot of love sir <3 thanks to you I'm getting the hang of it:)

Collectives™ on Stack Overflow

Entity Framework codefirst 1 to many relations

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related