DataTable通过dt.AsEnumerable()方法转换可用Linq查询,反之,Linq也可以转化为DataTable
DataTable newDt = query1.CopyToDataTable<DataRow>();
var query1 =
    from stu in dtStu.AsEnumerable()
    from score in dtScore.AsEnumerable()
    where stu.Field<int>("ScoreID") == score.Field<int>("ScoreID")
    where (int)stu["Age"] > 20
    select stu;

//通过CopyToDataTable()方法创建新的副本
DataTable newDt = query1.CopyToDataTable<DataRow>();
 foreach (var item in newDt.AsEnumerable())  
 {  
     System.Console.WriteLine(item["Name"]);  
}

05-02 19:57