title: Entity Framework - Combining data on two rows
body: <p>I have two tables.</p>
  
  <pre><code>Orders
  OrderID | UserID | OrderTotal
  1       |    1   |  100
  2       |    2   |  110
  3       |    1   |  120
  
  Users
  UserId | ProprtyType | PropertyValue
  1      |     1       |    Kevin
  1      |     2       |    Nolan
  1      |     1       |    FirstName
  1      |     2       |    Surname
  </code></pre>
  
  <p>Using the following Query </p>
  
  <pre><code>var query = from orders in context.Orders
  join users in context.Users on orders.UserID equals user.UserID
  where userData.Type == 211 || userData.Type == 212
  
  1       |    1   |  100 | Kevin
  1       |    1   |  100 | Nolan
  2       |    2   |  110 | FirstName
  2       |    2   |  110 | Surname
  3       |    1   |  120 | Kevin
  3       |    1   |  120 | Nolan
  </code></pre>
  
  <p>Is it possible in Entity frame work to combine the results so it returns the following</p>
  
  <pre><code>1       |    1   |  100 | Kevin     | Nolan
  2       |    2   |  110 | FirstName | Surname
  3       |    1   |  120 | Kevin     | Nolan
  </code></pre>
  
  <p>Or</p>
  
  <pre><code>1       |    1   |  100 | Kevin Nolan
  2       |    2   |  110 | FirstName Surname
  3       |    1   |  120 | Kevin Nolan
  </code></pre>
  
  <p>Thanks</p>