Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
Register
Login
22
Reply
convert sql query to linq
vidhya
Jun 27 2013 12:26 AM
2.1k
Reply
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.
Post
Reset
Cancel
Answers (
22
)
Next Recommended Forum
C# linq accessing the app.config file
convert sql to linq -- left join -- getting error