title: Entity Framework. View return duplicate records
body: <p>I use Entity Framework that contains view. And I have query:</p>
  
  <pre><code>var data = this.context.vwRevenues
      .Where(x =&gt; x.revenue &gt;= 0);
      .OrderByDescending(x =&gt; x.year)
      .ThenByDescending(x =&gt; x.month)
      .Take(10)
      .ToList();
  </code></pre>
  
  <p>This query returns set of entities, but 1st entity equals 5th. </p>
  
  <pre><code>data[0] == data[4] // true
  </code></pre>
  
  <p>I take sql script for this query from sql tracer and run it into SQL Management Studio,
  it returns different records.</p>