title: Getting only specific columns in entity framework lambda join
body: <p>I am surprised I cannot find a solution for this on the web, but wording the search terms was a bit difficult. The question I have is about generating entity SQL that only returns the needed columns in a group join using Lambda syntax.</p>
  
  <p>The following is a "toy" example. I am not joining on two entities, rather on an enumerated list and an entity. And tunnelling is not an acceptable answer. I need to apply this to a much larger problem using a group join and select many.</p>
  
  <pre><code>var result1 = clientprofiles.Join(Context.Adjusters,
  c =&gt; c.AdjusterId,
  a =&gt; a.AdjusterId,
  (c, a) =&gt; new {a.ClientAccountId}).ToList();
  </code></pre>
  
  <p>Using Julie Lehrman's Entity profiler, I see that the query is being generated to select every record in the rows that meet the join criteria. How do I pare it down so it only selects the ClientAccountId field in this example?</p>