我正在创建一个ASP.NET Core API应用程序,并依赖于EF Core。我有这样定义的实体:
I'm creating an ASP.NET Core API app, and relying on EF Core. I have entities defined like this:
public class AppUser : IdentityUser { public string FirstName { get; set; } public string LastName { get; set; } [InverseProperty(nameof(Post.Author))] public ICollection<Post> Posts { get; set; } = new List<Post>(); } public class Post { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } public string AuthorId { get; set; } [ForeignKey("AuthorId")] public virtual AppUser Author { get; set; } [InverseProperty(nameof(Like.Post))] public ICollection<Like> Likes { get; set; } = new List<Like>(); [InverseProperty(nameof(Comment.Post))] public ICollection<Comment> Comments { get; set; } = new List<Comment>(); }其中评论和喜欢是其他一些实体。请注意,为简洁起见,我简化了实体。然后,我想获取用户的帖子,还包括喜欢 c和发表评论的评论。因此,我做了这样的事情:
Where Comment and Like are some other entities. Please note that I have simplified the entities for brevity. Then, I want to get the Posts of a user, but also include the Likes and Comments that a post has gotten. So, I did something like this:
return _context.Users .Include(u => u.Location) .Include(u => u.Posts) .ThenInclude(p => p.Comments) .ThenInclude(c => c.Owner) .Include(u => u.Posts) .ThenInclude(p => p.Likes) .ThenInclude(l => l.Giver) .Where(u => u.Id == userId) .FirstOrDefault();现在,这很好用,但是如您所见,我正在呼叫 .include(u = u.Posts)两次。有没有一种方法可以在同一属性上两次调用 ThenInclude ,而又没有两次实际编写 Include 语句?
Now, this works fine, but as you can see I'm calling .Include(u = u.Posts) twice. Is there a way to call ThenInclude twice on same property, without actually writing the Include statement also twice?
推荐答案不能将 ThenInclude 与多个导航属性一起使用。您必须具有 Include 。
You cannot use ThenInclude with multiple navigation properties. You have to have Include.
这里是错误。
更多推荐
如何在EF Core中两次调用ThenInclude?
发布评论