Datatable Group By multiple columns

Help
1

Hi all,

I’m trying to group a datatable by several columns and for the other columns apply different functions (sum, count, first, etc.).

The original table looks like:
ID | Name | Value | Date
A | John | 1 | 1-1-2019
B | Mary | 2 | 1-1-2019
A | John | 3 | 1-2-2019
B | Mary | 4 | 1-2-2019
C | Antoine | 5 | 1-2-2019

Query looks like:
Group by ID and Name, Sum(Value), First(Date)

Output should be:
A | John | 4 | 1-1-2019
B | Mary | 6 | 1-1-2019
C | Antoine | 5 | 1-2-2019

I’ve done it on MS Access and I am trying to convert to Linq or something to do on an Assign. Here is the MSAccess query:
SELECT dt1.[ID], dt1.[Name], Sum(dt1.[Value]), First(dt1.[Date])
FROM dt1
GROUP BY dt1.[ID], dt1.[Name];

I think this is a little upgrade from balareva package, but I can’t get it to work =).

Thanks in advance!