linq到sql不计算所有列

我有一张桌子叫 Game ,其中包含4列玩家id。我还有一个名为 Player . 当我试图统计一个玩家参加过的所有游戏时,我只得到游戏中第一列的玩家 游戏 桌子。

player.Games.Count();

Blue1 ...

我还尝试创建一个方法来手动选择所有游戏:

public int GetPlayerGames(int playerID)
{
    return (from game in db.Games
            where game.Blue1 == playerID
            || game.Blue2 == playerID
            || game.Red1 == playerID
            || game.Red2 == playerID
            select game).Count();
}

return from player in db.Players
       where GetPlayerGames(player.ID) > 0
       select player;

我得到这个错误:
Method 'Int32 GetPlayerGames(Int32)' has no supported translation to SQL.