12
Reply

convert sql to linq -- left join -- getting error

vidhya

vidhya

Jun 28 2013 1:17 AM
4.3k
need to convert sql to linq.

 
select p.firstname,p.lastname,a.assignmentname,asg.pointsawarded,a.pointspossible,a.duedatetime,asg.submissiondatetime
from person2 p
inner join coursesectionroster cs
on cs.personid = p.personid
inner join assignment a
on a.coursesectionid = cs.coursesectionid
left join assignmentsubmission asg
on a.assignmentid=asg.assignmentid
where cs.coursesectionid='b78a6efe-ac77-4e49-806a-fc2fad71068b'
and cs.courserole=2

Upload Source Code  Select only zip and rar file.
Answers (12)