vidhya

vidhya

  • NA
  • 324
  • 88.2k

convert sql query to linq

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

Answers (22)