convert sql query to linq

Question

Hi friends,

I need to convert sql query into linq. I have placed my query for your reference.

  select p.firstname,p.lastname,a.assignmentname,

a.makeavailable,a.pointspossible,a.duedatetime

from person2 p

inner join coursesectionroster cs

on cs.personid = p.personid 

inner join assignmentsubmission asn

on asn.coursesectionrosterid = cs.coursesectionrosterid

inner join assignment a

on a.assignmentid = asn.assignmentid 

where cs.coursesectionid='b78a6efe-ac77-4e49-806a-fc2fad71068b' 

and cs.courserole=2