title: Is there any way to join equal tables in the same Model and in the same Controller?
body: <p>I’ve done an ASP.NET Web Application project and I have added two ADO.NET Entity Data Model elements from Database with their corresponding Controller.</p>
  
  <p>The fact is that both Database contain the same tables, with the same structure, but with different data. For example, in both Database there is this Table:</p>
  
  <pre><code>public partial class User
  {
      public long id { get; set; } // Autoincrement
      public string bd { get; set; }
      public string username { get; set; }
      public string password { get; set; }
      public short role { get; set; }
  }
  </code></pre>
  
  <p>Having only 2, the redundancy when using 2 Models and 2 Controller, was not a big problem, but now I want to add more Databases with the same characteristics (a User table with the same structure, but different data)</p>
  
  <p>Is there any way for all tables to join and have a single Controller? And, in addition, the Controller would allow me to do: </p>
  
  <p>•GET all: get all the data from all the User tables</p>
  
  <p>•GET /id/bd: get the data with id and bd passed in the url</p>
  
  <p>•POST: add a new User in the Database stored in the bd attribute</p>
  
  <p>•PUT / id : modify the data with id and Database stored in the bd attribute</p>