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");