title: Casting Linq to IEnumerable <Datarow>
body: <p>I'm creating winForm app,In that Onbutton click i gather  Data Tables from of Two database  Mysql and Sqlite database. 
  I getting Casting error while on casting Linq query to IEnumerable to make fetch query values to DataTable to make display in DataGrid view.</p>
  
  <pre><code>private void button1_Click(object sender, EventArgs e)
  {
  
      var obj = new table1TableAdapter();  //Mysql Table Adapter
      var obj2 = new Table1TableAdapter(); // Sqlite Table Adapter
      var ds = new DataSet();
      ds.Tables.Add(obj.GetData());
      ds.Tables.Add(obj2.GetData());
      var tab1 = ds.Tables[0];
      var tab2 = ds.Tables[1];
      var query = from o in tab1.AsEnumerable()
                  join od in tab2.AsEnumerable()
                  on o.Field&lt;string&gt;("Name") equals od.Field&lt;string&gt;("Name")
                  select new
                  {
                      Name = o.Field&lt;string&gt;("Name"),
                      Rollno = od.Field&lt;Int64&gt;("rollno"),
                      Book = o.Field&lt;string&gt;("Book")
                  };
  
      var q2 = (IEnumerable&lt;DataRow&gt;)query; //Unable to cast object of type &lt;JoinIterator&gt;
  
      DataTable orderTable = q2.CopyToDataTable();
      dataGridView1.DataSource = orderTable;
  }
  </code></pre>