title: How do I write a LINQ query to combine multiple rows into one row?
body: <p>I have one table, 'a', with id and timestamp. Another table, 'b', has N multiple rows referring to id, and each row has 'type', and "some other data".</p>
  
  <p>I want a LINQ query to produce a <strong>single row</strong> with id, timestamp, and "some other data" x N. Like this:</p>
  
  <pre><code>
      1 | 4671 | 46.5 | 56.5
  </code></pre>
  
  <p>where 46.5 is from one row of 'b', and 56.5 is from another row; both with the same id.</p>
  
  <p>I have a working query in SQLite, but I am new to LINQ. I dont know where to start - I don't think this is a JOIN at all.</p>
  
  <pre><code>
      SELECT 
         a.id as id,
         a.seconds,
         COALESCE(
           (SELECT b.some_data FROM
             b WHERE
               b.id=a.id AND b.type=1), '') AS 'data_one',
         COALESCE(
           (SELECT b.some_data FROM
             b WHERE
               b.id=a.id AND b.type=2), '') AS 'data_two'
  
         FROM a first
         WHERE first.id=1
         GROUP BY first.ID
  </code></pre>