使用Linq/Lambda将DataTable转换为字典

using System;
using System.Data;
using System.Linq;

public class Program
{
    public static void Main()
    {
        // 创建一个示例的DataTable
        DataTable dataTable = new DataTable();
        dataTable.Columns.Add("ID", typeof(int));
        dataTable.Columns.Add("Name", typeof(string));
        dataTable.Rows.Add(1, "John");
        dataTable.Rows.Add(2, "Jane");
        dataTable.Rows.Add(3, "Tom");

        // 使用Linq/Lambda将DataTable转换为字典
        var dictionary = dataTable.AsEnumerable()
            .ToDictionary(row => row.Field<int>("ID"), row => row.Field<string>("Name"));

        // 打印字典中的键值对
        foreach (var kvp in dictionary)
        {
            Console.WriteLine("Key: " + kvp.Key + ", Value: " + kvp.Value);
        }
    }
}

Key: 1, Value: John
Key: 2, Value: Jane
Key: 3, Value: Tom