Need advice on model design using Entity Framework 4.1 Code First and base types

Question

I need some advice on part of my model I am designing. As you can see in my Rfi entity, I have a collection of BaseImpact types. There will be several types of impacts that can be added to that collection. Each impact type has its own properties. As an example I created a Cost Impact and a Schedule Impact. Now, these are not very different, but you get the idea. I am trying to figure out how I can use this same type of model and then add the mappings / relationships to the database. I'd really like the BaseImpact to be abstract, but I may need it to be in the DB, but I am not usre.

    public class Rfi
        {
            public ICollection<BaseImpact> Impacts { get; set; }
        }

        public class BaseImpact : BaseEntity
        {
            #region Navigation
            public virtual ICollection<Comment> Comments { get; set; }
            #endregion
        }

        public class CostImapct: BaseImpact
        {
            public decimal Cost { get; set; }

        }
        public class ScheduleImpact: BaseImpact
        {
            public int days { get; set; }

        }

jlew · Accepted Answer · 2011-05-23 14:33:41Z

1

See this series of posts on different options for modeling inheritance hierarchies in EF Code First.

answered May 23, 2011 at 14:33

jlew

10.7k1 gold badge39 silver badges61 bronze badges

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

1 Comment

DDiVita Over a year ago

I had ran accross those posts before and totally didn;t think about that! this is exactly what I was looking for!

Collectives™ on Stack Overflow

Need advice on model design using Entity Framework 4.1 Code First and base types

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