Current version is incompatible with latest Microsoft.Azure.Functions.Worker.Sdk 2.0.2

[phelm1-landolakes]

• Azure Functions SQL Extension or Extension Bundle Version: 3.1.376
• Is this a deployed or local function: na
• What type of Database are you using? na

Steps to Reproduce:

1. Upgrade Microsoft.Azure.Functions.Worker.Sdk 2.0.1 => 2.0.2
2. Attempt to Build

The build will fail as Microsoft.Azure.Functions.Worker.Sdk is now Net8.0.

`obj\Debug\net8.0\WorkerExtensions\WorkerExtensions.csproj : error NU1605: Warning As Error: Detected package downgrade: System.Runtime.Caching from 8.0.0 to 6.0.1. Reference the package directly from the project to select a different version.

obj\Debug\net8.0\WorkerExtensions\WorkerExtensions.csproj : error NU1605: Microsoft.Azure.Functions.Worker.Extensions -> Microsoft.Azure.WebJobs.Extensions.Sql 3.1.376 -> Microsoft.Data.SqlClient 5.2.2 -> System.Runtime.Caching (>= 8.0.0)

obj\Debug\net8.0\WorkerExtensions\WorkerExtensions.csproj : error NU1605: Microsoft.Azure.Functions.Worker.Extensions -> Microsoft.Azure.WebJobs.Extensions.Sql 3.1.376 -> System.Runtime.Caching (>= 6.0.1)
`

[zmilleson]

I am also getting this when I try to build locally or using an Azure Pipelines agent.

"Microsoft.Azure.Functions.Worker.Extensions.Sql" Version="3.1.376"
Function Core Tools version: 4.0.7030

\obj\Debug\net8.0\WorkerExtensions\WorkerExtensions.csproj : error NU1605: Warning As Error: Detected package downgrade:
System.Runtime.Caching from 8.0.0 to 6.0.1. Reference the package directly from the project to select a different version.

\obj\Debug\net8.0\WorkerExtensions\WorkerExtensions.csproj : error NU1605: Microsoft.Azure.Functions.Worker.Extensions
-> Microsoft.Azure.WebJobs.Extensions.Sql 3.1.376 -> Microsoft.Data.SqlClient 5.2.2 -> System.Runtime.Caching (>= 8.0.0)

\obj\Debug\net8.0\WorkerExtensions\WorkerExtensions.csproj : error NU1605: Microsoft.Azure.Functions.Worker.Extensions
-> Microsoft.Azure.WebJobs.Extensions.Sql 3.1.376 -> System.Runtime.Caching (>= 6.0.1)

[Charles-Gagnon]

We've confirmed this is an issue with the package and are working on getting a fix out. In the meantime, please use Microsoft.Azure.Functions.Worker.Sdk <= 2.0.1 in your functions.

[Charles-Gagnon]

We've published the 3.1.512 version of the package, which should resolve the issue with the newer versions of the SDK. Let us know if you see any further issues!