title: Fill list object using dapper c#
body: <p>I have two table in my database like this:</p>
  
  <p><img src="https://i.stack.imgur.com/D0yBD.png" alt="enter image description here"></p>
  
  <p>And i have this class:</p>
  
  <pre><code>   class Ean
     {
          public string Code{ get; set; }
     }
  
     class Article
     {
          public int Id { get; set; }
          public string Name { get; set; }
          public List&lt;Ean&gt; BarCode { get; set; }
     }
  
  List&lt;Article&gt; arts = new List&lt;Article&gt;();
  </code></pre>
  
  <p>I create a list of article , and with a query using <strong>dapper</strong>. I would like to fill this list with the name of the article but also with a list of related <strong>ean</strong> Article. I try to do this query: </p>
  
  <pre><code>SELECT ART.ID AS ID, ART.NAME AS NAME,EAN.EAN AS BARCODE
  FROM ART,EAN
  WHERE ART.ID = EAN.ID_ART;
  </code></pre>
  
  <p>and in c#..  </p>
  
  <pre><code>arts = conn.Query&lt;Article&gt;(query, null, transaction).ToList();
  </code></pre>
  
  <p>but don't work. How i can do? Thank's.. Any suggestion is welcome. </p>