title: Object properties of selected objects are null
body: <p>I'm having trouble with Linq to entities framework.</p>
  
  <p>Here is my code:</p>
  
  
  
  <pre class="lang-cs prettyprint-override"><code>var activeScoreList = (from s in context.Score
                         join i in context.Import on s.import.importId equals i.importId
                         where i.isActive.Value == 1
                         select s).ToList();
  
  foreach (Score s in activeScoreList)
  {
      if (s.User.userId == loggedOnUserId) { // Here
          ...
      }
  }
  </code></pre>
  
  <p>I have several <code>Score</code> objects in my database, and the foreign key <code>UserId</code> is <code>NOT NULL</code>.<br>
  However, there is <strong>always an exception</strong> at the <code>if</code> line. <code>User</code> property is always <code>null</code>.</p>
  
  <p>I'm new to Linq, so I may have missed a configuration thing somewhere. Is this behaviour normal? Do I have to make a new query for each score to get the <code>User</code> object?</p>