title: Select individual columns in EF
body: <p>How do I select individual columns instead of doing <code>select l</code>?</p>
  
  <pre><code>IEnumerable&lt;LEA&gt; query = default(IEnumerable&lt;LEA&gt;);
  
  var query = from l in bModel.leas
              join la in bModel.LondonAreas on l.LEANo equals la.LeaNo
              where la.AreaNo == areaNo
              select l;
  </code></pre>