How to convert SQL Join query into LINQ?

See more:

LINQ

I need to convert this code into linq query.

The query below gives me to correct total in MS SQL.

SELECT SUM(t1.itemPrice + t2.itemPrice) as TOTAL_AMOUNT_DUE FROM table1 t1, table2 t2 WHERE r.userID = u.userID

I am trying to get this same code to work in linq query so I can use it in my project MVC4.

My attempt is failing mainly b/c I am not very familiar with Linq just yet. here it is:

--Linq--
var query = (from t1 in db.table1 join table2 in db.table2 on t1.userID equals t2.userID
select new { SUM(t2.itemPrice + t1.itemPrice) });

Obviously the above don't work. Can anyone help?

Thank you!

Ceci