22
Reply

convert sql query to linq

vidhya

vidhya

Jun 27 2013 12:26 AM
2.1k
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

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