title: Using abstract entity
body: <p>I'd like to use generalization in my EF model (.edmx) using an abstract base entity.</p>
  
  <p>So I made the following</p>
  
  <p><img src="https://i.stack.imgur.com/TCHs7.png" alt="abstract entity"></p>
  
  <p>I set the abstraction flag on the base entity</p>
  
  <p><img src="https://i.stack.imgur.com/52ETS.png" alt="abstract setting"></p>
  
  <p>The expected output would something like the following</p>
  
  <p><img src="https://i.stack.imgur.com/nRMwT.png" alt="desired result"></p>
  
  <p>However when I look at the generated SQL I notice that it's creating my abstract base table which I do not want.
  The problem is that the Id in either ConcreteEntity_A or ConcreteEntity_B can be the same so if it's also being added to the base entity I have a problem.</p>
  
  <pre><code>-- Creating table 'AbstractBaseSet'
  CREATE TABLE [dbo].[AbstractBaseSet] (
      [Id] int NOT NULL
  );
  GO
  
  -- Creating table 'AbstractBaseSet_ConcreteEntity_A'
  CREATE TABLE [dbo].[AbstractBaseSet_ConcreteEntity_A] (
      [Id] int  NOT NULL
  );
  GO
  
  -- Creating table 'AbstractBaseSet_ConcreteEntity_B'
  CREATE TABLE [dbo].[AbstractBaseSet_ConcreteEntity_B] (
      [Id] int  NOT NULL
  );
  GO
  </code></pre>
  
  <p>Have I misunderstood the use of abstract entities?</p>