Making a basic ASP.NET MVC 5 model

Question

I'm modelling a simple ASP.NET MVC 5 application for learning purposes.

A user should be able ask and answer questions (A user can only give one answer to a question). How should this be done?

User 1 --> * Answer * --> 1 Question

Because this is my first time modelling with this framework I'm not sure if everything is efficient and if I make good user of the [] statements, should I make adjustments?

User:

public class User
{
    [Key]
    public int UserID { get; set; }
    ...

    public virtual ICollection<Question> Questions { get; set; }
    public virtual ICollection<Answer> Answers{ get; set; }
}

Question:

public class Question
{
    [Key]
    public int QuestionID { get; set; }

    [Required]
    public int UserID { get; set; }

    ....
}

Answer:

public class Answer
{
    [Key]
    public int AnswerID{ get; set; }

    [Required]
    public int UserID { get; set; }
    [Required]
    public int QuestionID { get; set; }

    public virtual User User { get; set; }
    public virtual Question Question { get; set; }
}

Question class should have public virtual ICollection<Answer> Answers{ get; set; }. — adiga
– adiga, Commented Nov 14, 2014 at 12:50

Community · Accepted Answer · 2017-05-23 12:22:10Z

3

Here is a good example for this.

You should use Index attribute with the same name. Such as

 public class Question
       {
       [Index("IX_QuestionAndUser", 1, IsUnique = true)]
        public int QuestionID { get; set; }

        [Index("IX_QuestionAndUser", 1, IsUnique = true)]
        public int UserID { get; set; }

       }

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Nov 14, 2014 at 12:48

cCcik

1074 bronze badges

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

Comments

Shan Khan · Accepted Answer · 2014-11-14 18:40:17Z

1

As you will be going with Entity framework. Following are the useful resources for relation ship in code first models.

Relations in Entity framework

answered Nov 14, 2014 at 18:40

Shan Khan

10.4k18 gold badges69 silver badges115 bronze badges

Collectives™ on Stack Overflow

Making a basic ASP.NET MVC 5 model

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related