title: Entity - Linq to Sql Only load a part of the entity
body: <p>If I use entity framework with linq to sql to query it and I have an object Person but I only need two properties of that object, what's in memory will be load, the entire object ?</p>
  
  <p>Example : </p>
  
  <p>I got the entity Person with properties : Name, Age, Address, Country, Language ...</p>
  
  <p>I only need to use the property Name and Age. So I got no need to load the address, country and other property ... what will be in memory and what type of query will be ask to SQL ?</p>
  
  <p>If my Linq query is :</p>
  
  <pre><code>public IQueryable&lt;Person&gt; FindAllPersons()
  {
      return from person in db.Persons
             select person;
  }
  </code></pre>
  
  <p>And later in code I only call the Name and Age property of each Person in the list.</p>