Refer the linq query for example :
var result = tblSystems.GroupBy (s => 1).Select (s => new
val1 = s.Sum (x => x.fkInfoSubCatID),
val2 = s.Sum (x => x.fkCompanyID),
val3 = s.Sum (x => x.eventResult)
Hope this will help you.
Mark the answer if it helped you.
DNS Gold Member
"Failure is the path of least persistence"