Nullable object must have a value error when I try to proyect a nullable navigation property

[ComptonAlvaro]

Hello:

I am using Entity Core 7.

I have this model:

public class Document
{
    public long Id;
    public DocumentCategory? Category;

}

public class DocumentCategory
{
    public long Id;
    public string Name;
}

I would like to do this query:

private Expression<Func<Document, Document>> GetProjeciton()
{
    return x => new Document
    {
        Id = x.Id,
        Category = new DocumentCategory()
        {
            Id = x.Category.Id,
            Name = x.Category.Name,
        }
    };
}


return await _context.Documents
    .AsNoTracking()
    .Select(GetProjeciton())
    .Where(x => x.Id == 1)
    .ToListAsync();

But I get an exception: "Nullable object must have a value."

I have check the T-SQL the database receives, and it is correct, it is left join, but it seems that when EF Core tries to create the objects, it fails.

I have another properties that can't be null so the databse always return a value and it works as expected.

How could set the category in the projection?

Thanks.

[ComptonAlvaro]

In this issue they give the solution: #22517

I have to add a check if it is null in this way:

        Catetogy = x.Category == null ? null : new DocumentCategory()
        {
            Id = x.Category.Id,
            Name= x.Category.name,
        },

Thanks.