[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