[RESOLVED] Linq DataTable

[mickey_pt]

Hello

Need a quick help, with a query...

I need to get a list of distinct names inside the data table and the sum of values for each one.
I know some basic stuff about linq, but i don't know how to put the distinct and the sums together.

The SQL Query:

SELECT DISTINCT username,
                [Sum1] = SUM(day1),
                [Sum2] = SUM(day2)
FROM dbo.History
WHERE username LIKE '%something%'
GROUP BY username

How can i do this query in linq?

Thanks

[mickey_pt]

Solved.

Dim query = From reg In _dt.AsEnumerable
Group reg By username= registo.Field(Of String)("username") Into gpUsers = Group
        Select New With {
                   .UserName= username,
                   .Day1= gpUsers.Sum(Function(reg) reg.Field(Of Decimal)("day1")),
                   .Day2= gpUsers.Sum(Function(reg) reg.Field(Of Decimal)("day2")),
          }