DataTable转换为dynamic

您可以使用以下代码将DataTable转换为dynamic：

dynamic ToDynamic(DataTable dt)
{
    var dynamicDt = new List<dynamic>();
    foreach (DataRow row in dt.Rows)
    {
        dynamic dyn = new ExpandoObject();
        foreach (DataColumn column in dt.Columns)
        {
            var dic = (IDictionary<string, object>)dyn;
            dic[column.ColumnName] = row[column];
        }
        dynamicDt.Add(dyn);
    }
    return dynamicDt;
}

使用示例：

DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Rows.Add(1, "John");
dt.Rows.Add(2, "Jane");

dynamic dynamicDt = ToDynamic(dt);
foreach (var row in dynamicDt)
{
    Console.WriteLine($"Id: {row.Id}, Name: {row.Name}");
}