title: Create a list nested within an object in a LINQ query
body: <p>I've got two tables that looks like this:</p>
  
  <pre><code>-- Houses
  houseid personid
  1       11
  1       12
  1       13
  2       232
  2       5533
  2       40
  
  
  -- People
  personid person name
  11       John
  12       Jane
  13       Zoe
  </code></pre>
  
  <p>and a class</p>
  
  <pre><code>class House
  {
      List&lt;string&gt; people_name {get; set;};
  }
  </code></pre>
  
  <p>And I want to return an object <code>House</code> that contains a List on all the people's names that live in a given house. The closest I got to achieving it was returning an IQueryable in the object <code>House</code>, because you cannot call <code>ToList</code> from within a query:</p>
  
  <pre><code>LINQ to Entities does not recognize the method 'System.Collections.Generic.List`1[System.String]
  ToList[String](System.Collections.Generic.IEnumerable`1[System.String])'
   method, and this method cannot be translated into a store expression.
  </code></pre>