HasQueryFilter on Relationship

[MoishyS]

I would like to be able to have properties with filtered relationships. for example.

public class Blog
{
    public int BlogId { get; set; }
    public string Name { get; set; }
    public string Url { get; set; }

    public List<Post> Posts { get; set; }

    public List<Post> DeletedPosts { get; set; }
    public List<Post> PopularPosts { get; set; }
}

public class Post
{
    public int PostId { get; set; }
    public string Title { get; set; }
    public string Content { get; set; }
    public int Votes { get; set; }
    public bool IsDeleted { get; set; }

    public Blog Blog { get; set; }
}

and OnModelCreating

modelBuilder.Entity<Blog>()
        .HasMany(b => b.DeletedPosts)
        .WithOne(p => p.Blog)
        .HasQueryFilter(p => p.IsDeleted);

modelBuilder.Entity<Blog>()
        .HasMany(b => b.PopularPosts)
        .WithOne(p => p.Blog)
        .HasQueryFilter(p => p.Votes > 100);

[ajcvickers]

Duplicate of #20339. Please vote (👍) for that issue.

[roji]

Duplicate of #20339