c# - GroupJoin 和包含

Question

在 GroupJoin 之后，我想包括 Book.Authors，因为字段 Book.Authors 将为空。但我不能。我应该怎么做才能解决这个问题？

Queryable<NewRead> recent = Repository.NewReads.Where(x => x.UserId == usersId);

var newFavs = IsAuthorized ? Repository.NewFavs.Where(x => x.UserId == UserId) : Repository.NewFavs.Where(x => false);

var recentFavorite = recent.GroupJoin(newFavs,
                             x => x.BookId,
                             y => y.BookId,
                             (x, y) => new {Recent = x, Favorite = y, x.Book});

我试过:

var recent = Repository.NewReads.Include("Book.Authors")
                   .Where(x => x.UserId == usersId);

和

var newFavs = IsAuthorized ? Repository.NewFavs.Include("Book.Authors").Where(x => x.UserId == UserId) : Repository.NewFavs.Where(x => false);

所有这一切。它在 GroupJoin 之前起作用，但在 Authors 字段丢失之后起作用。如果我添加:

var recentFavorite = recent.GroupJoin(newFavs,
                             x => x.BookId,
                             y => y.BookId,
                             (x, y) => new {Recent = x, Favorite = y, x.Book, x.Book.Authors});

一切正常，但这不是解决方案。

Answer 1

你可以做到

var recent = Repository.NewReads.Include(x => x.Book.Authors)
                       .Where(x => x.UserId == usersId);