nested where query in Entity Framework

Question

i have a class like this

public class Survey
    {
        public Survey()
        {
            SurveyResponses=new List<SurveyResponse>();
        }

        public Guid SurveyId { get; set; }

        public string SurveyName { get; set; }

        public string SurveyDescription { get; set; }

        public virtual ICollection<Question> Questions { get; set; }

        public virtual ICollection<SurveyResponse> SurveyResponses { get; set; }
    }

and a Question class like this

 public class Question
    {

        public Guid QuestionId { get; set; }

        public string QuestionText { get; set; }

        public QuestionType QuestionType { get; set; }

        public virtual ICollection<Option> Options { get; set; }

        public bool IsOtherAllowed { get; set; }

        public virtual ICollection<Answer> Answers { get; set; }

    }

i want to write a query to select a survey which contains a particular question

something along these lines

 Survey s1 = db.Surveys.Where(s => s.Questions.Where(q => q.QuestionId == "1eb56610-853d-4a9e-adc7-e0ec069390b7"));

Fabiano · Accepted Answer · 2011-11-07 08:25:09Z

8

Survey s1 = db.Surveys
    .Where(s => s.Questions.Any(q => q.QuestionId == "1eb56610-853d-4a9e-adc7-e0ec069390b7"))
    .FirstOrDefault();

answered Nov 7, 2011 at 8:25

Fabiano

5,2148 gold badges44 silver badges70 bronze badges

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

2 Comments

taher chhabrawala Over a year ago

Thank you fabiano...do u know any good tutorial for building such lamda expressions

Fabiano Over a year ago

I would read the msdn articles msdn.microsoft.com/en-us/library/bb397926.aspx and take a look at the available extension methods msdn.microsoft.com/en-us/library/…. Or just google for some tutorials. also note that not all LINQ extensions are available in Linq to Entities: msdn.microsoft.com/en-us/library/bb738550.aspx

Collectives™ on Stack Overflow

nested where query in Entity Framework

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related