Convert DataTable to List

Question

public static List<TSource> ToList<TSource>(this DataTable dataTable) where TSource : new()

{

var dataList = new List<TSource>();

const BindingFlags flags = BindingFlags.Public | BindingFlags.Instance | BindingFlags.NonPublic;

var objFieldNames = (from PropertyInfo aProp in typeof(TSource).GetProperties(flags)

select new

{

Name = aProp.Name,

Type = Nullable.GetUnderlyingType(aProp.PropertyType) ?? aProp.PropertyType

}).ToList();

var dataTblFieldNames = (from DataColumn aHeader in dataTable.Columns

select new { Name = aHeader.ColumnName, Type = aHeader.DataType }).ToList();

var commonFields = objFieldNames.Intersect(dataTblFieldNames).ToList();

foreach (DataRow dataRow in dataTable.AsEnumerable().ToList())

{

var aTSource = new TSource();

foreach (var aField in commonFields)

{

PropertyInfo propertyInfos = aTSource.GetType().GetProperty(aField.Name);

var value = (dataRow[aField.Name] == DBNull.Value) ? null : dataRow[aField.Name]; //if database field is nullable

//propertyInfos.SetValue(aTSource, dataRow[aField.Name], null);

propertyInfos.SetValue(aTSource, value, null);

}

dataList.Add(aTSource);

}

return dataList;

}