从数据库返回并非所有数据

本文关键字：数据数据库返回 | 更新日期: 2023-09-27 17:53:58

 using (var db = new ConnectToDB())
        {
            var matches = db.Matches;
            var matchesToReturn = new List<SimpleMatch>();
            foreach (var item in matches)
            {
                var match = new SimpleMatch();
                match.Id = item.Id;
                match.Home = item.Home.Name;
                match.Guest = item.Guest.Name;
                match.HomeTeamGoals = item.Result.HomeTeamGoals;
                match.GuestTeamGoals = item.Result.GuestTeamGoals;
                matchesToReturn.Add(match);
            }
            return matchesToReturn;
        }

所有item都有id和DateMatch，但是item。家,项目。客人,项目。结果= = null

img返回

从数据库返回并非所有数据

确保加载相关对象。例如:

foreach (var item in matches.Include(x => x.Home).Include(x => x.Guest).Include(x => x.Result))
{
    ...
}