title: Getting a SQL View via Entity Framework returns incorrect result
body: <p>I have a very simple View in SQL Server which looks something like this, Where the <strong>Show</strong> is a result of <strong>LEFT JOIN</strong> with <strong>Character</strong> table:</p>
  
  <pre><code>+---------+----------+----------------------+  
  |  Name   | Surname  |         Show         |  
  +---------+----------+----------------------+  
  | Enoch   | Thompson | The Boardwalk Empire |  
  | Anthony | Soprano  | The Sopranos         |  
  | Walter  | White    | Breaking Bad         |  
  +---------+----------+----------------------+  
  </code></pre>
  
  <p>When I get this table via Entity Framework's <code>context.CharacterView.ToList()</code> in my application, the result looks like this: </p>
  
  <pre><code>+---------+----------+----------------------+  
  |  Name   | Surname  |         Show         |  
  +---------+----------+----------------------+  
  | Enoch   | Thompson | The Boardwalk Empire |  
  | Anthony | Soprano  | The Boardwalk Empire |  
  | Walter  | White    | The Boardwalk Empire |  
  +---------+----------+----------------------+  
  </code></pre>
  
  <p>However, in DB the CharacterView is <em>as it should be.</em></p>
  
  <hr>
  
  <h2>Create view query</h2>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE VIEW CharacterView AS
  SELECT c.Name AS [Name], 
         c.Surname AS [Surname], 
         s.Name AS [Show]
  
  FROM   [dbo].[Characters] AS c LEFT OUTER JOIN
         [dbo].[Shows] AS scen ON c.ShowId = s.Id
  </code></pre>
  
  <hr>