When i was working on my web project i suffer with some difficulty to join two distinct table Questions and Tags with one Middle table QuestionTags and get the result with questions and its related tags.
The Problem was to join the below table.
for joining the above table i used this query.
Dim questions = From qt In context.QuestionsTags Join q In context.Questions On qt.QuestionID Equals q.QuestionID Join t In context.Tags On qt.TagID Equals t.TagID Group t By q Into qts = Group Select q, qts Where q.IsPublished = True
Above query group related question tag and join it with questions.