title: Entity Framework select single value from row
body: <p>I am using Entity Framework from .NET 3.5</p>
  
  <p>I have two tables with 0-1 to many relation. Let's say Citizen and City. Each citizen has foreign key column (ID) that connects him to City.</p>
  
  <p>When i select single citizen, i also need to select the name of the city where he lives.
  Because city table contains tons of data that is not really related to citizen, so i don't want to retrieve it from database to save some bandwidth. </p>
  
  <p>Currently i am using Include() function, but it grabs all the data from the City related to citizen, while i need only name. </p>
  
  <p>Is there a way to write a query to select single cell from the whole row in EF and without creating new classes or interfaces or repositories? 
  Here is my Include:</p>
  
  <pre><code>            Citizen citizen = db.Citizens.Include("Cities").First(p =&gt; p.citizen_id == id);
  </code></pre>