title: how concatenate multiple rows in LINQ with two tables?
body: <p>I try to concatenate multiple rows in a single row with 2 tables which one of them has a foreing key </p>
  
  <p>I have this tables:</p>
  
  <p>Table Printer:</p>
  
  <pre><code>PrinterID    Name      Description 
  --------------------------------
  1          Printer1   Description1
  2          Printer2   Description2
  </code></pre>
  
  <p>Table Resolution:</p>
  
  <pre><code>ResolutionID    Measure    PrinterId
  --------------------------------
  1              123            1
  2              234            1
  3              345            2
  4              456            2
  </code></pre>
  
  <p>I need this in the GridView:</p>
  
  <pre><code>PrinterID          Name              Description          Resolution
  ------------------------------------------------------------------------
  1                 Printer1           Description1          123, 234
  2                 Printer2           Description2          345, 456
  </code></pre>
  
  <p>I have this code but I am stuck</p>
  
  <pre><code>    var Printer = from tPrinter in Context.Printer
                    join tResolution in Context.Resolution on tPrinter.PrinterId equals tResolution.PrinterId into collection2
                    from subcase2 in collection2.DefaultIfEmpty()
                    where tPrinter.DisableDate == null
  
                    select new
                    {
                        tPrinterPrinterId = tPrinter.PrinterId,
                        tPrinterName = tPrinter.Name,
                        tPrinterDescription = tPrinter.Description,
                        tCountryName = tPrinter.City1.State.Country.Name,
                        tStateName = tPrinter.City1.State.Name,
                        tCityName = tPrinter.City1.Name
                    };
  
    return Printer
  </code></pre>