title: Mapping multiple Tables to one Entity
body: <p>I work on a legacy database that stores Users in one of two tables (<code>ActiveUsers</code>, <code>InactiveUsers</code>). In my DbContext I defined the following DbSets to work with the two Usertables:</p>
  
  <pre><code>public DbSet&lt;User&gt; ActiveUsers{ get; set; }
  public DbSet&lt;User&gt; InactiveUsers{ get; set; }
  </code></pre>
  
  <p>How can I map the <code>User</code> entity to the tables? I'm stuck with these Mappings:</p>
  
  <pre><code>// OK
  modelBuilder.Entity&lt;User&gt;().ToTable("ActiveUsers");
  
  // Overwrites the mapping above :(
  modelBuilder.Entity&lt;User&gt;().ToTable("InactiveUsers");
  </code></pre>
  
  <p>I think I need to configure the DbSets somehow... </p>
  
  <p>PS: <a href="http://msdn.microsoft.com/en-us/library/bb738537.aspx" rel="nofollow">This MSDN article</a> seems to solve my problem for "classic" EF with an EDMX.</p>