title: Convert multiple rows into a single row with multiple columns using LINQ query
body: <p>Let's consider following two tables:</p>
  
  <p><strong>Guest</strong></p>
  
  <pre><code>GuestID    FirstName    Email     
  ----------------------------------------------
  3          Sam          sam.billings@gmail.com
  </code></pre>
  
  <p>and </p>
  
  <p><strong>GuestAddress</strong></p>
  
  <pre><code>AddressID    GuestID    AddressType    IsPrimaryAddress   Address1
  -------------------------------------------------------------------
  3            3          1              True               ABC
  4            3          2              False              XYZ
  </code></pre>
  
  <p>I expect output something like this:</p>
  
  <pre><code>GuestID    FirstName   Email         IsPrimaryAddress  Address1  IsPrimaryAddress Address1
  3          Sam         sam.billings@gmail.com  True    ABC       False             XYZ 
  </code></pre>
  
  <p>I found this type of solution for SQL Server, but I can not convert it to a linq query. I tried linq query but it returns two rows. Is this possible with a linq query?</p>