Queryable.cs

public class ArticleReadingQuryables 
    {
        private readonly AppDbContext _context;

        public ArticleReadingQuryables(AppDbContext dBContext)
        {
            _context = dBContext;
        }

        public IQueryable<Article> Published()
        {
            return _context.Article.Where(e => e.IsPublished)
                .Include(e => e.Publisher)
                .OrderByDescending(e => e.PublishedOn);
        }

        public IQueryable<Article> WithReactionsAndComments()
        {
            return _context.Article.Include(e => e.Comments).ThenInclude(e => e.Replies);
        }

        public IQueryable<Article> WithReactions()
        {
            return _context.Article.Include(e => e.Reactions.Where(r => r.IsLiked || r.IsRead));
        }

        public IQueryable<Article> Latest()
        {
            return Published()
                .OrderByDescending(e => e.PublishedOn);
        }
}