I want to execute following sql using linq in c# select sum(EDAmount) from accounts a inner join entriesdetail ed on a.Acode =ed.acode inner join entries e on ed.eid = e.eid and e.edate > '1/1/2009' group by ed.acode Following are the entities Accounts - ACode Entry - EID - EDate EntryDetail - EDID - EID - EDAmound - ACode