Versioning Entity Framework entities

Question

We are looking to implement a versioning scheme for our EF Code first data models. Take the following two models as an example:

public class Question
{
    public int Id { get; set; }
    public int Version { get; set; }
    public string Text { get; set; }

    public ICollection<Alternative> Alternatives { get; set; }
}

public class Alternative
{
    public int Id { get; set; }
    public int Version { get; set; }
    public string Text { get; set; }
    public bool IsCorrect { get; set; }

    public int QuestionId { get; set; }
    public virtual Question Question { get; set; }
}

Here, the idea is that a question has multiple alternatives. We want to link an alternative to a question's Id, but not its Version. Likewise, a question can get a reference to all alternatives which has a QuestionId equal to its Id.

How would this be modeled best? Feel free to change the models.

Don't model after EntityFramework. Just model your database without thinking about EntityFramework at all. — JustAnotherUserYouMayKnow
– JustAnotherUserYouMayKnow, Commented Apr 10, 2013 at 12:41

Joey Gennari · Accepted Answer · 2013-04-10 12:56:52Z

I looked at this for several minutes and maybe totally missed the boat, but this might be an option:

public class Question
{
    public int QuestionId { get; set; }
    public QuestionText Primary { get; set; }
    public ICollection<QuestionText> Alternatives { get; set; }
}

public class QuestionText
{
    public int QuestionTextId { get; set; }
    public ICollection<QuestionTextVersion> Versions { get; set; }
    public QuestionTextVersion CurrentVersion { get; set; }
}

public class QuestionTextVersion
{
    public int QuestionTextVersionId { get; set; }
    public int Version { get; set; }
    public string Text { get; set; }
}

Theory here is that question and alternatives are all grouped together in one object. The question text is stored on the version, and you should be able to access the current version from the selected alternatives. You could change the Question object to either provide access to all QuestionText objects or just the alternatives.

Then again I could have totally missed the point of your Alternative.

Collectives™ on Stack Overflow

Versioning Entity Framework entities

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