antissoft / wurenji

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace NCC.Common 
{
    public static class DataTableExtentions
    {
        /// <summary>
        /// DataTable 转List 集合
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static List<Dictionary<string, object>> DataTableToDicList(this DataTable dt)
        {
            return dt.AsEnumerable().Select(
                    row => dt.Columns.Cast<DataColumn>().ToDictionary(
                    column => column.ColumnName.ToLower(),
                    column => row[column]
                    )).ToList();
        }
    }
}