Use subquery in linq query

Question

How can I construct the below sql query in linq query to get the results ?

SELECT PageNumber from LMS_SurveyQuestion WHERE SurveyQuestionID IN
(SELECT  SurveyQuestionID from LMS_SurveyQuestionOptionChoice 
WHERE NextPageNumber = 4) and SurveyID = 1

Saurabh Srivastava · Accepted Answer · 2017-02-10 07:05:40Z

1

Have a look at this article. Basically, if you want to implement SQL IN query in LINQ, you need to construct an inner query first, and then use the Contains() method. Here's my attempt:

var innerQuery = (from log in LMS_SurveyQuestionOptionChoice where log.NextPageNumber = 4 select log.SurveyQuestionID);

var result = (from f in LMS_SurveyQuestion where innerQuery.Contains(f.SurveyQuestionID) && f.SurveyID = 1 select f);

Hope this will help.

edited Feb 10, 2017 at 7:05

answered Feb 10, 2017 at 6:56

Saurabh Srivastava

1,12314 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

David Over a year ago

But where is SurveyID = 1 is used ? SurveyID belongs to LMS_SurveyQuestion.

Arsalan Qaiser · Accepted Answer · 2017-02-10 07:04:04Z

1

try this

var result = from l in LMS_SurveyQuestion 
             let lsq = from l_S in LMS_SurveyQuestionOptionChoice 
             where l_S.NextPageNumber = 4
             select l_S.SurveyQuestionID 
             where lsq.Contains(l.SurveyQuestionID) and l.surveyid = 1
             select l.PageNumber;

edited Feb 10, 2017 at 7:04

answered Feb 10, 2017 at 6:54

Arsalan Qaiser

4572 gold badges7 silver badges27 bronze badges

1 Comment

David Over a year ago

But where is SurveyID = 1 is used ? SurveyID belongs to LMS_SurveyQuestion.

Collectives™ on Stack Overflow

Use subquery in linq query

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related