IEnumberable<<anonymous type canot be convert to IEnumerable<DataRow> C# : <p>I want to insert a Linq query into a Datatable but i get the following error 
IEnumberable"&lt;&lt;" anonymous type canot be convert to IEnumerable. Why i get this Error and how to fix it?</p>

<pre><code>IEnumerable&lt;DataRow&gt; sql = from dr in Csvdaten.AsEnumerable()
                      join dr2 in Csvimportdaten.AsEnumerable() on dr.Field&lt;string&gt;("customer_id_spam") equals dr2.Field&lt;string&gt;("customer_id_spam")
                      select new
                      {
                          CAMPAIGN_ID = Convert.ToInt32(dr2["CAMPAIGN_ID"]),
                          MEDIUM_CODE = Convert.ToString(dr2["MEDIUM_CODE"])
                      };

            DataTable dt = sql.CopyToDataTable();
</code></pre>
