Select from multiple tables using linq

Question

I am trying to execute the following SQL statement using linq:

SELECT TTT.SomeField
FROM Table1 as T, Table2 as TT, Table3 as TTT
WHERE (T.NumberID = 100 OR T.NumberID = 101)
  AND T.QuestionID = 200
  AND T.ResponseID = TT.ResponseID
  AND TT.AnswerID = TTT.AnswerID

Essentially getting one field from a third table based on primary/foreign key relationships to the other 2 tables. It is expected to have a single result every time.

Can you post examples of the 3 tables and the result you want out? — skyfoot
– skyfoot, Commented Jun 28, 2013 at 14:35

Andrei · Accepted Answer · 2013-06-28 14:44:37Z

2

var query = from t in db.Table1
            join tt in db.Table2 on t.ResponseID equals tt.ResponseID
            join ttt in db.Table3 on tt.AnswerID equals ttt.AnswerID
            where (t.NumberID == 100 || t.NumberID == 101) && t.QuestionID == 200
            select ttt.SomeField

If you always expect single result, you can wrap this in ().Single(), or, if there might be no results found, in ().SingleOrDefault().

edited Jun 28, 2013 at 14:44

answered Jun 28, 2013 at 14:37

Andrei

56.8k10 gold badges92 silver badges114 bronze badges

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

1 Comment

Jonesopolis Over a year ago

sure thing! also I think he wants TTT.somefield. Not to be 'that guy'

Lucas · Accepted Answer · 2013-06-28 14:36:39Z

0

If I understand you correct. You should read something about Joins I guess. here

answered Jun 28, 2013 at 14:36

Lucas

3,5306 gold badges35 silver badges48 bronze badges

Collectives™ on Stack Overflow

Select from multiple tables using linq

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related