How to calculate total hours and group projects based on Id in linq

See more:

C#

SQL

LINQ

Hi Friends,

I have a table

date            | ProjectID| hours | Task
----------------------------------------------------------
2012-01-01 1:00 | 1    | 10               | Coding
2012-01-01 1:00 | 2    | 10               | Design
2012-01-21 2:00 | 1    | 1                | R&D
2012-01-01 2:00 | 2    | 9                | Support
2012-01-01 3:00 | 1    | 3                | Design
2012-02-30 3:00 | 1    | 3                | Coding

i want to display like this

Project-1
total hours : 17
Date : 2012-01-01 1:00 - 2012-02-30 3:00
Task : Coding,R&D, Design

Any help will be appreciated....

Regards
Chinnu