使用linq将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.Columns.Add("Age", typeof(int));

        dataTable.Rows.Add(1, "John", 25);
        dataTable.Rows.Add(2, "", 30);
        dataTable.Rows.Add(3, "Alice", DBNull.Value);

        // 使用LINQ查询并过滤空值
        var dictionary = dataTable.AsEnumerable()
            .Where(row => row.ItemArray.All(field => field != DBNull.Value && !string.IsNullOrEmpty(field.ToString())))
            .ToDictionary(row => row.Field<int>("ID"), row => new
            {
                Name = row.Field<string>("Name"),
                Age = row.Field<int>("Age")
            });

        // 打印结果
        foreach (var item in dictionary)
        {
            Console.WriteLine($"ID: {item.Key}, Name: {item.Value.Name}, Age: {item.Value.Age}");
        }
    }
}