$metadata endpoint does not work when creating the host from a Console Application

Assemblies affected
ASP.NET Core OData 9.0.0

Describe the bug
Creating a console application then adding a WebHost to it containing oData, makes the /$metadata endpoint to not be created, generating a 404 - NotFound.

Reproduce steps

• Create Console Application (.net 8)
• Add FrameworkReference and oData in the .csproj file:

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <OutputType>Exe</OutputType>
    <TargetFramework>net8.0</TargetFramework>
    <ImplicitUsings>enable</ImplicitUsings>
    <Nullable>enable</Nullable>
  </PropertyGroup>
    <ItemGroup>
	    <FrameworkReference Include="Microsoft.AspNetCore.App" />
    </ItemGroup>
    <ItemGroup>
      <PackageReference Include="Microsoft.AspNetCore.OData" Version="9.0.0" />
    </ItemGroup>

</Project>

• Configure Program.cs:

using System.Net;
using Microsoft.AspNetCore.OData;
using Microsoft.OData.Edm;
using Microsoft.OData.ModelBuilder;

namespace TestePesquisaConsole;

internal class Program
{
    static void Main(string[] args)
    {
        Host.CreateDefaultBuilder()
            .ConfigureWebHostDefaults(
                webHost =>
                {
                    webHost.UseStartup<Startup>();
                    webHost.ConfigureKestrel(kestrel =>
                    {
                        kestrel.Listen(IPAddress.Any, 5900);
                    });
                })
            .Build()
            .Run();
    }

    private class Startup
    {
        public void ConfigureServices(IServiceCollection services)
        {
            services
                .AddControllers()
                .AddOData(option =>
                {
                    option.Select().Filter().OrderBy().Expand().Count().SetMaxTop(null).AddRouteComponents("Pesquisa", GetEdmModel());
                    option.TimeZone = TimeZoneInfo.Utc;
                });

            static IEdmModel GetEdmModel()
            {
                ODataConventionModelBuilder builder = new ODataConventionModelBuilder();
                builder.EntitySet<ClientePsqDto>(nameof(ClientePsqBo)).EntityType.Page(null, null);
                return builder.GetEdmModel();
            }
        }

        public void Configure(IApplicationBuilder app)
        {
            app.UseRouting();

            app.UseEndpoints(
                routeBuilder =>
                {
                    routeBuilder.MapControllers();
                });
        }
    }
}

• Go to: http://localhost:5900/Pesquisa/$metadata and get's 404

Data Model

public class ClientePsqDto
{
    [Key]
    public long Identificador { get; set; }

    public string Nome { get; set; } = string.Empty;
}

EDM (CSDL) Model
404 - NotFound

Request/Response
http://localhost:5900/Pesquisa/$metadata
404 - NotFound

Expected behavior
Return the metadata

Additional context
In the project file if I change the Project Sdk it works:
Doesn't Work:
<Project Sdk="Microsoft.NET.Sdk">
Works:
<Project Sdk="Microsoft.NET.Sdk.Web">

Reproduce the issue using the supplied .csproj and Program.cs, comparing Microsoft.NET.Sdk with Microsoft.NET.Sdk.Web. Start by tracing how the console-hosted WebHost registers controllers and OData route components, then verify the /Pesquisa/$metadata request. Done means the endpoint returns metadata with the console SDK configuration, without requiring the Web SDK.