连接两个DataTables时选择LINQ查询中的所有可用字段

// 假设有两个DataTables：table1和table2

var query = from row1 in table1.AsEnumerable()
            join row2 in table2.AsEnumerable()
            on row1.Field<int>("ID") equals row2.Field<int>("ID")
            select new
            {
                Field1 = row1.Field<string>("Field1"),
                Field2 = row1.Field<int>("Field2"),
                Field3 = row2.Field<string>("Field3"),
                Field4 = row2.Field<decimal>("Field4"),
                // 添加其他可用字段
            };

foreach (var result in query)
{
    // 处理查询结果
    Console.WriteLine(result.Field1);
    Console.WriteLine(result.Field2);
    Console.WriteLine(result.Field3);
    Console.WriteLine(result.Field4);
    // 处理其他字段
}