9.4.0-preview SQL Server Package results in Nuget package downgrade

[afscrome]

Is there an existing issue for this?

• I have searched the existing issues

Describe the bug

A csproj containing just the following two two package references fails with a package downgrade error around Microsoft.Extensions.Caching.Memory which causes the package to fail to build.

	  <PackageReference Include="Aspire.Hosting.AppHost" Version="9.4.0-preview.1.25312.1" />
	  <PackageReference Include="Aspire.Hosting.SqlServer" Version="9.4.0-preview.1.25312.1" />

      Warning As Error: Detected package downgrade: Microsoft.Extensions.Caching.Memory from 9.0.4 to 8.0.1. Reference the package directly from the project to select a different version.
       aspire91.AppHost -> Aspire.Hosting.SqlServer 9.4.0-preview.1.25312.1 -> Microsoft.Data.SqlClient 6.0.2 -> Microsoft.Extensions.Caching.Memory (>= 9.0.4)
       aspire91.AppHost -> Aspire.Hosting.SqlServer 9.4.0-preview.1.25312.1 -> Microsoft.Extensions.Caching.Memory (>= 8.0.1)

Expected Behavior

Aspire.Hosting.SqlServer should install correctly

Steps To Reproduce

dotnet restore the following project

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

  <Sdk Name="Aspire.AppHost.Sdk" Version="9.4.0-preview.1.25312.1" />

  <PropertyGroup>
    <OutputType>Exe</OutputType>
    <TargetFramework>net9.0</TargetFramework>
    <ImplicitUsings>enable</ImplicitUsings>
    <Nullable>enable</Nullable>
    <IsAspireHost>true</IsAspireHost>
    <UserSecretsId>7f64dcec-74ce-45b6-8e1b-b493c03bd387</UserSecretsId>
  </PropertyGroup>

	<ItemGroup>
	  <PackageReference Include="Aspire.Hosting.AppHost" Version="9.4.0-preview.1.25312.1" />
	  <PackageReference Include="Aspire.Hosting.SqlServer" Version="9.4.0-preview.1.25312.1" />
  </ItemGroup>

</Project>

Exceptions (if any)

    S:\aspire91\aspire91.AppHost\aspire91.AppHost.csproj : error NU1605:
      Warning As Error: Detected package downgrade: Microsoft.Extensions.Caching.Memory from 9.0.4 to 8.0.1. Reference the package directly from the project to select a different version.
       aspire91.AppHost -> Aspire.Hosting.SqlServer 9.4.0-preview.1.25312.1 -> Microsoft.Data.SqlClient 6.0.2 -> Microsoft.Extensions.Caching.Memory (>= 9.0.4)
       aspire91.AppHost -> Aspire.Hosting.SqlServer 9.4.0-preview.1.25312.1 -> Microsoft.Extensions.Caching.Memory (>= 8.0.1)

Restore failed with 1 error(s) in 1.5s

.NET Version info

.NET SDK:
 Version:           9.0.300
 Commit:            15606fe0a8
 Workload version:  9.0.300-manifests.af4147de
 MSBuild version:   17.14.5+edd3bbf37

Runtime Environment:
 OS Name:     Windows
 OS Version:  10.0.22621
 OS Platform: Windows
 RID:         win-x64
 Base Path:   C:\Program Files\dotnet\sdk\9.0.300\

.NET workloads installed:
 [aspire]
   Installation Source: VS 17.14.36109.1
   Manifest Version:    8.2.2/8.0.100
   Manifest Path:       C:\Program Files\dotnet\sdk-manifests\8.0.100\microsoft.net.sdk.aspire\8.2.2\WorkloadManifest.json
   Install Type:              Msi

Configured to use loose manifests when installing new manifests.

Host:
  Version:      9.0.5
  Architecture: x64
  Commit:       e36e4d1a8f

.NET SDKs installed:
  6.0.428 [C:\Program Files\dotnet\sdk]
  8.0.408 [C:\Program Files\dotnet\sdk]
  9.0.105 [C:\Program Files\dotnet\sdk]
  9.0.203 [C:\Program Files\dotnet\sdk]
  9.0.300 [C:\Program Files\dotnet\sdk]

.NET runtimes installed:
  Microsoft.AspNetCore.App 6.0.36 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
  Microsoft.AspNetCore.App 7.0.7 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
  Microsoft.AspNetCore.App 7.0.20 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
  Microsoft.AspNetCore.App 8.0.15 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
  Microsoft.AspNetCore.App 8.0.16 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
  Microsoft.AspNetCore.App 9.0.4 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
  Microsoft.AspNetCore.App 9.0.5 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
  Microsoft.NETCore.App 6.0.36 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]
  Microsoft.NETCore.App 8.0.15 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]
  Microsoft.NETCore.App 8.0.16 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]
  Microsoft.NETCore.App 9.0.4 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]
  Microsoft.NETCore.App 9.0.5 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]
  Microsoft.WindowsDesktop.App 6.0.36 [C:\Program Files\dotnet\shared\Microsoft.WindowsDesktop.App]
  Microsoft.WindowsDesktop.App 8.0.15 [C:\Program Files\dotnet\shared\Microsoft.WindowsDesktop.App]
  Microsoft.WindowsDesktop.App 8.0.16 [C:\Program Files\dotnet\shared\Microsoft.WindowsDesktop.App]
  Microsoft.WindowsDesktop.App 9.0.4 [C:\Program Files\dotnet\shared\Microsoft.WindowsDesktop.App]
  Microsoft.WindowsDesktop.App 9.0.5 [C:\Program Files\dotnet\shared\Microsoft.WindowsDesktop.App]

Other architectures found:
  x86   [C:\Program Files (x86)\dotnet]
    registered at [HKLM\SOFTWARE\dotnet\Setup\InstalledVersions\x86\InstallLocation]

Environment variables:
  Not set

global.json file:
  Not found

Learn more:
  https://aka.ms/dotnet/info

Download .NET:
  https://aka.ms/dotnet/download

Anything else?

No response

[davidfowl]

@joperezr another TFM issue

[joperezr]

Interesting, thanks for the find @afscrome. I'm wondering if we should just dual-target all integrations going forward so we can detect these issues and fix appropriately.

For instance, in this particular case, the fix would be that the net9 tfm wouldn't have the direct reference to pin the version of Microsoft.Extensions.Caching.Memory.

[DamianEdwards]

Would this be mitigated by us taking dependency updates more frequently? I know this is only a daily build and we'd take an update before releasing 9.4 for real, but this is still annoying when you hit it.