title: Linq to SQL to append multiple records with a delimiter
body: <p>Sorry for the bad title of the question apologies if it's a duplicate. </p>
  
  <p>I have two db tables:</p>
  
  <pre><code>Users                 Documents
  -------               --------- 
  ID                    ID
  Name                  DocumentName
                        UserID
  </code></pre>
  
  <p>Say I have 1 record in <code>Users</code></p>
  
  <pre><code>1, "bob" 
  </code></pre>
  
  <p>and three related records in <code>Documents</code></p>
  
  <pre><code>1, "Doc1", 1
  2, "Doc2", 1
  3, "Doc3", 1
  </code></pre>
  
  <p>I want to generate a result set:</p>
  
  <pre><code>1, "bob", "Doc1, Doc2, Doc3"
  </code></pre>
  
  <p>I've tried various things involving merging of multiple result sets but get the error: <code>Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator.</code></p>
  
  <p>How should I go about doing this.</p>