EF核心5，在子集合中按日期排序实体

public class Blog
{
    public int Id { get; set; }
    public string Title { get; set; }
    public List<Post> Posts { get; set; }
}

public class Post
{
    public int Id { get; set; }
    public string Title { get; set; }
    public DateTime PublishedDate { get; set; }
    public int BlogId { get; set; }
}

using (var context = new YourDbContext())
{
    var blog = context.Blogs
        .Include(b => b.Posts)
        .FirstOrDefault(b => b.Id == blogId);

    if (blog != null)
    {
        var sortedPosts = blog.Posts.OrderBy(p => p.PublishedDate).ToList();
    }
}

var sortedPosts = blog.Posts.Where(p => p.PublishedDate != null)
                           .OrderBy(p => p.PublishedDate)
                           .ToList();

var sortedPosts = blog.Posts.OrderBy(p => p.PublishedDate)
                           .Take(10) // 只取前10条记录
                           .ToList();