LINQ expression for Data Table agregation

Help Something Else
2

@SONYC
Welcome to the forum

Assign Activity
dtResult = yourOrigDTVar.Clone

Assign Activity
dtResult =

(From d in yourOrigDTVar.AsEnumerable
Group d by k=d("Database").toString.Trim into grp=Group
Let jr = String.Join(",",grp.Select(Function (x) x("Role")))
Let rr = String.Join(",",grp.Select(Function (x) x("Reference")))
Let ra = New Object(){k, jr, rr}
Select r = dtResult.Rows.Add(ra)).CopyToDataTable
1 Like