问题描述
我想使用 OR 语句对 LINQ 进行 JOIN.
I want to do a JOIN with LINQ using an OR statement.
这是我开始的 SQL 查询:
Here is the SQL query I'm starting with:
SELECT t.id FROM Teams t INNER JOIN Games g ON (g.homeTeamId = t.id OR g.awayTeamId = t.id) AND g.winningTeamId != 0 AND g.year = @year GROUP BY t.id
我无法将该 ON 子句转换为 LINQ.这就是我所在的位置:
I'm having trouble converting that ON clause to LINQ. This is where I'm at:
var y = from t in db.Teams join g in db.Games on t.ID equals g.AwayTeamID //missing HomeTeamID join where g.WinningTeamID != 0 && g.Year == year group t by t.ID into grouping select grouping;
我想我可以使用:
join g in db.Games on 1 equals 1 where (t.ID == g.HomeTeamID || t.ID == g.AwayTeamID)
这有效,但似乎有点像hacky.有没有更好的办法?
and this works but seems kind of seems hacky. Is there a better way?
推荐答案
where 子句应用布尔条件,因此使用||"是要走的路.您可以链接多个 where 子句,但我相信这会给您一个和"操作,而不是或".
The where clause applies a boolean condition, so using "||" is the way to go. You can chain multiple where clauses but I believe that will give you a "and" operation, rather than an "or".