Filtered include query is changed after using ProjectTo

[MaticDiba]

Source/destination types

I created this simple example:

public class PostDto
{
    public int Id { get; set; }
    public string Title { get; set; }
}
public class BlogDto
{

    public int Id { get; set; }
    public string Url { get; set; }

    public List<PostDto> Posts { get; set; } = new List<PostDto>();
}
public class Blog
{
    public int Id { get; set; }
    public string Url { get; set; }

    public List<Post> Posts { get; set;  } = new List<Post>();
}
public class Post
{
    public int Id { get; set; }
    public string Title { get; set; }
    public bool Active { get; set; }
    public string Content { get; set; }

    public List<Blog> Blogs { get; } = new List<Blog>();
}

Mapping configuration

var config = new MapperConfiguration(cfg => {
    cfg.CreateMap<Post, PostDto>();
    cfg.CreateMap<Blog, BlogDto>();
});
IMapper mapper = config.CreateMapper();

Version: 10.1.1

AutoMapper: 10.1.1
AutoMapper.Extensions.Microsoft.DependencyInjection: 8.1.1
Microsoft.EntityFrameworkCore: 5.0.9
Microsoft.EntityFrameworkCore.SqlServer: 5.0.9

Expected behavior

When I try to query blog entities with connected (active!) posts I get results as expected without using automapper.

This query is generated:

SELECT [b].[Id], [b].[Url], [t].[BlogsId], [t].[PostsId], [t].[Id], [t].[Active], [t].[Content], [t].[Title]
FROM [Blogs] AS [b]
LEFT JOIN (
    SELECT [b0].[BlogsId], [b0].[PostsId], [p].[Id], [p].[Active], [p].[Content], [p].[Title]
    FROM [BlogPost] AS [b0]
    INNER JOIN [Posts] AS [p] ON [b0].[PostsId] = [p].[Id]
    WHERE [p].[Active] = CAST(1 AS bit)
) AS [t] ON [b].[Id] = [t].[BlogsId]
ORDER BY [b].[Id], [t].[BlogsId], [t].[PostsId], [t].[Id]

Actual behavior

When I'm using ProjectTo, the query generated is missing filter for active flag.

SELECT [b].[Id], [b].[Url], [t].[Id], [t].[Title], [t].[BlogsId], [t].[PostsId]
FROM [Blogs] AS [b]
LEFT JOIN (
    SELECT [p].[Id], [p].[Title], [b0].[BlogsId], [b0].[PostsId]
    FROM [BlogPost] AS [b0]
    INNER JOIN [Posts] AS [p] ON [b0].[PostsId] = [p].[Id]
) AS [t] ON [b].[Id] = [t].[BlogsId]
ORDER BY [b].[Id], [t].[BlogsId], [t].[PostsId], [t].[Id]

In my result, all posts are present no matter the active flag.

Steps to reproduce

var blogsQuery = context.Blogs.Include(b => b.Posts.Where(b => b.Active == true));
var projectedQuery = blogsQuery.ProjectTo<BlogDto>(mapper.ConfigurationProvider);

I'm not sure this is expected behavior. Or am I doing something worng?

[lbargaoanu]

See this.

[MaticDiba]

Thanks.