LINQ Query using Group By

Question

I have a different answers associated with particulary QuestionID.I have to group the answers of each question.

 Question Table ---------- QuestionID QuizID QuestionText IsMultipleAnswers Answer Table -------- AnswerID QuestionID AnswerText IsCorrectAnswer

var query = from qst in context.Questions join ans in context.Answers on qst.QuestionID equals ans.QuestionID

What is the way to extend my query to group the answers associated with each questionID ?

Richard Ev · Accepted Answer · 2010-01-07 15:41:28Z

3

The 101 LINQ samples page for GroupBy might help.

answered Jan 7, 2010 at 15:41

Richard Ev

54.3k61 gold badges196 silver badges282 bronze badges

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

Comments

R. Martinho Fernandes · Accepted Answer · 2010-01-07 15:42:59Z

Just use the group by operator:

var query = from qst in context.Questions join ans in context.Answers on qst.QuestionID equals ans.QuestionID group ans by ans.QuestionID into groups select groups;

Collectives™ on Stack Overflow

LINQ Query using Group By

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related