Welcome use DataTableExtension!!
With DataTableExtension, you can easily convert a DataTable into any Entity Model.
e.g. using Dino.DataTableExtension;
//you can simply finish converting with just one line like below:
List<EntityModel> = dt.ToEntity<EntityModel>();
//or you can do it in this way:
List<EntityModel> entitys = dt.ToEntity(typeof(EntityModel));
//Grouping by a column, you can use GroupBy like below:
DataTable dt=sourceTable.GroupBy("colnamnName");
//Joining two tables together, you can use Join like below:
DataTable dt=leftTable.Join(rightTable, "colnamnName");
//Sumary a column values, you can use Sum like below:
int sum=dt.Sum<int> ("colnamnName");
//Exclude some row from a DataTable:
int dt=sourceTable.Exculde((DataTable)table,"colnamnName");