title: Entity framework 6 code first: what is the best implementation for a baseobject with 10 childobjects
body: <p>We have a baseobject with 10 childobjects and EF6 code first.</p>
  <p>Of those 10 childobjects, 5 have only a few (extra) properties, and 5 have multiple properties (5 to 20).
  We implemented this as table-per-type, so we have one table for the base and 1 per child (total 10).</p>
  <p>This, however, creates HUGE select queries with <code>select case</code> and <code>unions</code> all over the place, which also takes the EF 6 seconds to generate (the first time).</p>
  <p>I read about this issue, and that the same issue holds in the table-per-concrete type scenario.</p>
  <p>So what we are left with is table-per-hierachy, but that creates a table with a large number of properties, which doesn't sound great either.</p>
  <p>Is there another solution for this?</p>
  <p>I thought about maybe skip the inheritance and create a union view for when I want to get all the items from all the child objects/records.</p>
  <p>Any other thoughts?</p>