Query For EF core

hi
I have three tables that I want to have a Query in EF core?

table A

Id
Name

Table B

Id
Name

Table AB

AId
BId

I want all the names from Table B when AId == 1.

SELECT b.name
  FROM ab
INNER
  JOIN b
    ON b.bid = ab.bid
 WHERE ab.aid = 1 
1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.