How to use Entity Framework include with condition?

Question

Suppose that we have two entities, Posts and Comments. Posts has a navigation property to Comments and vice versa:

public virtual ICollection<Comment> Comments { get; set; }

And also Comments has a navigation property to User:

public virtual User User { get; set; }

Now, how to query all Posts including only the last comment (by comment creation date) and the user who created it?

@Mak to load all posts with all comments including user simply we do: _db.Posts.Include(p => p.Comments.Select(p => p.User)).ToList(); but because of performance issues I want only the last comment with user who creates that. — Mehdi JM
– Mehdi JM, Commented Jun 24, 2014 at 7:22

Rand Random · Accepted Answer · 2014-06-24 07:14:45Z

4

Not possible with the current version of EF but you can vote for it here https://entityframework.codeplex.com/workitem/47

answered Jun 24, 2014 at 7:14

Rand Random

7,47710 gold badges48 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1