How to convert sql query with addition and join to linq -

i have working sql query have been trying convert linq past couple of days. have read several posts both here , on various site, have not been successful in of attempts convert working linq query.

the parts having problems deal math (adding individual scores total_score value) , getting values schools table can pass them view.

here sql query:

select bowler_name, school_name, bowler_gm1, bowler_gm2, bowler_gm3, bowler_gm4, bowler_gm5, bowler_gm6, (isnull([bowler_gm1],0)+isnull([bowler_gm2],0)+isnull([bowler_gm3],0)+isnull([bowler_gm4],0)+isnull([bowler_gm5],0)+isnull([bowler_gm6],0)) total_score  bowlers  join schools on schools.school_id = bowlers.school_id  order total_score desc; 

here far linq query before things start breaking:

from s in db.schools join b in db.bowlers on s.school_id equals b.school_id select b; 

any appreciated. thanks!

something should on way.

from s in db.schools join b in db.bowlers on s.school_id equals b.school_id select new {   bowler_name = b.bowler_name,   ...   totalscore = bowler_gm1 + bowler_gm2 + bowler_gm3 ... }; 

note easier handle nulls if create bowlergame table gameid pk, bowlerid fk bowler, gamenumber game number , score game's score