Aspire.Hosting.SqlServer has dependency issues in 9.1 with TFM splitting

[aaronpowell]

Is there an existing issue for this?

• I have searched the existing issues

Describe the bug

When upgrading the Community Toolkit (which targets net8.0 and net9.0) we hit a problem with the Aspire.Hosting.SqlServer package and some transient dependencies:

dotnet restore                                                                                                                                                                                                                                                                                             
    D:\Aspire-CommunityToolkit\src\CommunityToolkit.Aspire.Hosting.SqlServer.Extensions\CommunityToolkit.Aspire.Hosting.SqlServer.Extensions.csproj : error NU1605:
      Warning As Error: Detected package downgrade: Microsoft.Extensions.Logging.Abstractions from 9.0.0 to 8.0.3. Reference the package directly from the project to select a different version. 
       CommunityToolkit.Aspire.Hosting.SqlServer.Extensions -> Aspire.Hosting.SqlServer 9.1.0 -> Microsoft.Data.SqlClient 6.0.1 -> Microsoft.Extensions.Caching.Memory 9.0.0 -> Microsoft.Extensions.Logging.Abstractions (>= 9.0.0)
       CommunityToolkit.Aspire.Hosting.SqlServer.Extensions -> Aspire.Hosting.SqlServer 9.1.0 -> Microsoft.Extensions.Logging.Abstractions (>= 8.0.3)
    D:\Aspire-CommunityToolkit\src\CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects\CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects.csproj : error NU1605:
      Warning As Error: Detected package downgrade: Microsoft.Extensions.Logging.Abstractions from 9.0.0 to 8.0.3. Reference the package directly from the project to select a different version.
       CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects -> Aspire.Hosting.SqlServer 9.1.0 -> Microsoft.Data.SqlClient 6.0.1 -> Microsoft.Extensions.Caching.Memory 9.0.0 -> Microsoft.Extensions.Logging.Abstractions (>= 9.0.0)
       CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects -> Aspire.Hosting.SqlServer 9.1.0 -> Microsoft.Extensions.Logging.Abstractions (>= 8.0.3)

This shows up in VS like so:

The problem seems to be due to the TFM splitting from the Microsoft.Data.SqlClient package and the upgrade to that in 9.1, but the hosting package isn't doing multiple TFM itself.

Expected Behavior

In-place upgrade should not result in large dependency failures like this.

Steps To Reproduce

1. Create a new Aspire 9.1 project
2. Add Aspire.Hosting.SqlServer to the app host
3. Configure multi-targetting TFM

It can be see on our CI too - /~https://github.com/CommunityToolkit/Aspire/actions/runs/13532723492/job/37818388929?pr=475

Exceptions (if any)

No response

.NET Version info

No response

Anything else?

You should be able to work around it by manually upgrading the dependency of Microsoft.Extensions.Logging.Abstractions to 9.0.2 when building for .NET 9.0.