Multi mapping each object with a list or collection using C# Dapper : <p>I am having trouble multi mapping the result from db to my objects. I want to map the production objects to a list that holds them to each workstation.</p>

<pre><code>Table1:
productProduction     Workstation
-----------------     -----------
es1                   cell_1
es2                   cell_1
es4                   cell_3
est3                  cell_4

table2 workstations:
Workstation   
----
cell_1
cell_2
cell_3
cell_4


public class Workstation {
   public string Cell { get; set; }
   public List&lt;Production&gt; {get; set;}
}

public class Production {
   public string product_name { get; set; }
}
</code></pre>
