title: left outer join in lambda/method syntax in Linq
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/584820/how-do-you-perform-a-left-outer-join-using-linq-extension-methods">How do you perform a left outer join using linq extension methods</a>  </p>
  </blockquote>
  
  
  
  <p>I can't find a left outer join example of Linq lambda (with extension methods), at least, not a clear one.</p>
  
  <p>Let's say I have the following table:</p>
  
  <pre><code>Parent
  {
      PID     // PK
  }
  
  Child
  {
      CID     // PK
      PID     // FK
      Text
  }
  </code></pre>
  
  <p>I want to join Parent with Child, and for every child missing, I want the default value for Text to be "[[Empty]]". How can I do this with linq lambda syntax?</p>
  
  <p>I currently have the following:</p>
  
  <pre><code>var source = lParent.GroupJoin(
      lChild,
      p =&gt; p.PID,
      c =&gt; c.PID,
      (p, g) =&gt;
          new // ParentChildJoined
          {
              PID = p.PID;
              // How do I add child values here?
          });
  </code></pre>