Very nice!
I've modified
ToCollection<t>(this DataTable dt)</t> extension function, so if
DataTable column names and class property names are different, then you can use this alternative:
public static List<t> ToCollection<t>(this DataTable table, Dictionary<string,> dic)
{
List<t> lst = new System.Collections.Generic.List<t>();
Type classType = typeof(T);
PropertyInfo[] propertyInfoList = classType.GetProperties();
List<datacolumn> columnsList = table.Columns.Cast<datacolumn>().ToList();
T t;
foreach (DataRow item in table.Rows)
{
t = (T)Activator.CreateInstance(classType);
foreach (PropertyInfo oneInfo in propertyInfoList)
{
try
{
DataColumn d = columnsList.Find(col => col.ColumnName == dic[oneInfo.Name]);
if (d != null) oneInfo.SetValue(t, item[dic[oneInfo.Name]], null);
}
catch
{
}
}
lst.Add(t);
}
return lst;
}</datacolumn></datacolumn></t></t></t></t>
Class
public class Person
{
public string FirstName { get; set; }
public string LastName { get; set; }
}
DataTable
public DataTable getTable()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("FIRST_NAME", typeof(string)));
dt.Columns.Add(new DataColumn("LAST_NAME", typeof(string)));
DataRow dr;
for (int i = 1; i < 11; i++)
{
dr = dt.NewRow();
dr["FIRST_NAME"] = "First Name" + i;
dr["LAST_NAME"] = "Last Name" + i;
dt.Rows.Add(dr);
}
return dt;
}
Convertion
DataTable table = getTable();
Dictionary<string,> dic = new Dictionary<string,>();
dic.Add("FirstName", "FIRST_NAME");
dic.Add("LastName", "LAST_NAME");
List<person> lst = table.ToCollection<person>(dic);</person></person>
