UseDotNet CI task not upgraded to match target framework

[mikadumont]

Description

Direct customer feedback:

When upgrading a .NET 6 project to .NET 10, the UseDotNet@2 pipeline task was only updated to 8.0.x instead of the target version. Should also consider recommending global.json for SDK version management.