title: Same entity from different tables/procedures
body: <p>I have 2 procedures (say A and B). They both return data with similar columns set (Id, Name, Count). To be more concrete, procedures results examples are listed below:</p>
  
  <pre><code>A:
  Id  Name  Count
  1   A     10
  2   B     11
  
  B:
  Id  Name  Count
  1   E     14
  2   F     15
  3   G     16
  4   H     17
  </code></pre>
  
  <p>The IDs are generated as <code>ROW_NUMBER()</code> as I don't have own identifiers for these records because they are aggregated values.<br>
  In code I query over the both results using the same class <code>NameAndCountView</code>.<br>
  And finally my problem. When I look into results after executing both procedures sequentially I get the following:</p>
  
  <pre><code>A:
  Id  Name  Count
  1   A     10    -&gt;|
  2   B     11    -&gt;|
                    |
  B:                |
  Id  Name  Count   |
  1   A     10    &lt;-|
  2   B     11    &lt;-|
  3   G     16
  4   H     17
  </code></pre>
  
  <p>As you can see results in the second set are replaced with results with the same IDs from the first. Of course the problem take place because I use the same class for retrieving data, right?<br>
  The question is how to make this work without creating additional <code>NameAndCountView2</code>-like class?</p>