LINQ 与 OR 连接

作者: 马桶污污污
来源: 51数据库
2022-12-08

问题描述

我想使用 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".

推荐阅读