title: Querying data from multiple disjoint tables (EF6)
body: <p>I am currently trying to automate a search task. Basically, what I have are multiple tables like this:</p>
  <ul>
  <li>TableA with columns: Id, PartNumber, Value, R</li>
  <li>TableB with columns: Id, PartNumber, Value, C</li>
  <li>TableC with columns: Id, PartNumber, Value, X</li>
  <li>...</li>
  </ul>
  <p>Basically multiple very similar tables. What I am now trying to do is, is to search for a text string in the fields &quot;PartNumber&quot; and &quot;Value&quot;. I don't mind if it occurs in any of the columns R,C,X.</p>
  <p>Is there a way to</p>
  <ol>
  <li>Query which table names exist</li>
  <li>Then execute the very same query on each of those tables</li>
  <li>Concatenate the results (I don't mind if the type differs in the list or if it becomes a new type)</li>
  </ol>
  <p>In case a new table is added, it should only be added to the context and then get automatically searched.</p>