title: Entity Framework better table/column count
body: <p>I was wondering on how to do the following:
  I have a base class like this:</p>
  
  <pre><code>public class BaseClass
  {
      [Key]
      public Guid Id { get; set; }
  
      [MaxLength(512)]
      public string Description { get; set; }
  
      public ICollection&lt;Article&gt; Articles { get; set; }
  }
  </code></pre>
  
  <p>And then I have 2 classes that inherit from the base:</p>
  
  <pre><code>public class ClassA : BaseClass 
  {
       // some properties
  }
  
  public class ClassB : BaseClass 
  {
       // some properties
  }
  </code></pre>
  
  <p>Now this generates the Articles database with columns for each class: <code>ClassA_Id</code>, <code>ClassB_Id</code>, ...</p>
  
  <p>Isn't there an way to have it generate less columns/tables? because when the application grows it will have more and more of those columns, which will be Null most of the time.</p>
  
  <p>I tried some mapping, but it creates a seperate table for each class (like: ClassAArticles, ClassBArticles, ...)
  Or complains that it can't have the same column mapped for 2 entities.</p>