title: Dynamic Linq Library can’t handling duplicate alias column names
body: <p>I am trying to collect the data from database by using Dynamic Linq Library <a href="https://www.nuget.org/packages/System.Linq.Dynamic.Library" rel="nofollow noreferrer">NeGet</a>. When I loop through it showing this error ‘The item with identity 'FirstName' already exists in the metadata collection’</p>
  
  <p>Seems like Dynamic Linq Library <a href="https://www.nuget.org/packages/System.Linq.Dynamic.Library" rel="nofollow noreferrer">NuGet</a> is can’t handle duplicate alias column names. </p>
  
  <p>I have two tables and it has One-On-Many relationship as follow, containing the same Columns names in Lead table and CoBorrower table.</p>
  
  <p>Table1: Lead </p>
  
  <p>Columns: LeadID, FirstName,DateCreated</p>
  
  <p>Table2: CoBorrower</p>
  
  <p>Columns: LeadID, CoBorrowerID,FirstName,Tax,DateCreated</p>
  
  <p>Here is my code snippet</p>
  
  <pre><code>var res = (from l in db.Leads
  join db.CoBorrower.GetAll()
  on l.LeadID equals cb.LeadID
  select new { l, cb }).AsQueryable();
  string myCustomCondition="FistName=myname";
  IQueryable iq = res.Where(myCustomCondition)
                  .OrderBy(reportBulder.Group1)
                  .Select("new(l.LeadID,l.FirstName,cb.FistName)")
                  .GroupBy("LeadID", "it")
                  .Select("new (it.Key as Key, it as Value)");
  foreach (dynamic group in iq)
  {
   string Key = group.Key.ToString();
   List&lt;dynamic&gt; items = new List&lt;dynamic&gt;();
    foreach (dynamic album in group.Value)
     {
      items.Add(album);
     }
   dataList.Add(Key, items);
  }
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/uKqyK.png" alt="enter image description here"></p>
  
  <p>I will appreciate your help in advance. </p>