SQL Server联接正在工作,linq不工作

此linq语句将不起作用:

var other = from g in picks
            join sp in _playersContext.SportPlayers
                    on g.SportPlayerID equals sp.ID
            select g;

此T-SQL语句返回数据:

SELECT * 
FROM draftpick dp
JOIN FF2018AllSportsPlayers.dbo.SportPlayer sp ON dp.SportPlayerID = sp.ID
WHERE dp.DraftTeamManagerID = 7

错误消息是:

Microsoft.EntityFrameworkCore.Utilities.Check.NotNull(T值,字符串参数名)