Merge multiple datatables with linq

Help Studio
, , , ,
1

I am having 4 datatables d1,d2,d3,d4
I need to merge all this four data table to d5 using linq query.

d5 will contain all datatables content

Could you please help

help datatable linq

2

we assume all datatables do have the same column structures, otherwise check the merge datatable activity

Assign Activity:
dt5 =
{dt1,dt2,dt3,dt4}.SelectMany(Function (x) x.AsEnumerable()).CopyToDataTable

3

Hey @Tate_S
Make sure that all data tables have the same schema. You can try use:

d5 = (From table In New DataTable() {d1, d2, d3, d4} 
      From row In table.AsEnumerable()
      Select row).CopyToDataTable()