DataTable 转换成匿名集合类

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

namespace ConsoleApplication15
{
public static class ListAndTableExtension
{
public static IList ToGenericList(this DataTable dataTable, Type GenericType)
{

Type typeMaster = typeof(List<>);
Type listType = typeMaster.MakeGenericType(GenericType);
IList list = Activator.CreateInstance(listType) as IList;
if (dataTable == null || dataTable.Rows.Count == 0)
return list;
var constructor = GenericType.GetConstructors(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance)
.OrderBy(c => c.GetParameters().Length).First();
var parameters = constructor.GetParameters();
var values = new object[parameters.Length];
foreach (DataRow dr in dataTable.Rows)
{
int index = 0;
foreach (ParameterInfo item in parameters)
{
object itemValue = null;
if (dr[item.Name] != null && dr[item.Name] != DBNull.Value)
{
itemValue = Convert.ChangeType(dr[item.Name], item.ParameterType);
}
values[index++] = itemValue;
}
list.Add(constructor.Invoke(values));
}
return list;
}

}
class Program
{
static void Main(string[] args)
{
var entity = new { Name = "item", ID = 0, GuidType = Guid.Empty };

DataTable dataTable = new DataTable();
dataTable.Columns.Add("Name", typeof(string));
dataTable.Columns.Add("ID", typeof(int));
dataTable.Columns.Add("GuidType", typeof(Guid));

for (int i = 0; i < 10; i++)
{
DataRow dr = dataTable.NewRow();
dr["Name"] = "STRING" + i;
dr["ID"] = i;
if (i % 2 == 0)
dr["GuidType"] = Guid.Empty;
else
{
dr["GuidType"] = DBNull.Value;
}
dataTable.Rows.Add(dr);
}
IList list = dataTable.ToGenericList(entity.GetType());
}
}
}

DataTable 转换成匿名集合类

原文：http://www.cnblogs.com/kexb/p/4948475.html