// Description: C# Extension Methods | Enhance the .NET Framework and .NET Core with over 1000 extension methods.
// Website & Documentation: https://csharp-extension.com/
// Issues: https://github.com/zzzprojects/Z.ExtensionMethods/issues
// License (MIT): https://github.com/zzzprojects/Z.ExtensionMethods/blob/master/LICENSE
// More projects: https://zzzprojects.com/
// Copyright ZZZ Projects Inc. All rights reserved.
using System.Collections.Generic;
using System.Data;
using System.Dynamic;

public static partial class Extensions
{
 /// <summary>
 /// Enumerates to expando objects in this collection.
 /// </summary>
 /// <param name="this">The @this to act on.</param>
 /// <returns>@this as an IEnumerable&lt;dynamic&gt;</returns>
 /// ###
 /// <typeparam name="T">Generic type parameter.</typeparam>
 public static IEnumerable<dynamic> ToExpandoObjects(this DataTable @this)
 {
 var list = new List<dynamic>();

 foreach (DataRow dr in @this.Rows)
 {
 dynamic entity = new ExpandoObject();
 var expandoDict = (IDictionary<string, object>) entity;

 foreach (DataColumn column in @this.Columns)
 {
 expandoDict.Add(column.ColumnName, dr[column]);
 }


 list.Add(entity);
 }

 return list;
 }
}