[ISSUE]: Add support for SQL SDK .sqlproj files

[aidanblacklumeris]

Prerequisites

• I have written a descriptive issue title
• I have searched issues to ensure it has not already been reported

GitVersion package

GitVersion.Tool

GitVersion version

6.4.0

Operating system

Windows

What are you seeing?

With the release of the SDK for SQL projects, there is a need to be able to version SQL projects, especially when publishing database projects to NuGet. Currently, dotnet gitversion /updateprojectfiles skips .SQLPROJ files.

What is expected?

When running GitVersion locally or on a build server, dotnet gitversion /updateprojectfiles should update .sqlproj files when they are using the SQL SDK. Legacy SSDT project files should continue to be skipped.

Steps to Reproduce

• Create a new SQL SDK project or open an existing project
• Ensure GitVersion is updated
• run dotnet gitversion /updateprojectfiles on the command line
• Output is echoed to the terminal, but the .sqlproj file is unchanged

RepositoryFixture Test

No response

Output log or link to your CI build (if appropriate).

[arturcic]

@aidanblacklumeris are you in the position to work on that? I would guide you where to look in the codebase

[arturcic]

tested copilot for that job

[aidanblacklumeris]

Thanks for jumping on this so quickly. I was just in the process of checking our OSS contribution policies 😆. I figured it probably wasn't a huge change, but we're in healthcare, so we have to do everything by the book. However, I did notice that Copilot pulled in the wrong namespace for SQL SDK projects - I added a comment on the PR, but it is already merged. CoPilot added checks for Microsoft.Build.Sql - the correct namespace for SQL SDK projects is <Project Sdk="MSBuild.Sdk.SqlProj/3.2.0">. It will need to account for possible changes to the version number.

[arturcic]

oh, ok then I guess I can have a small follow up PR, does it need to have a specific version?

[arturcic]

I think I will change check if the Sdk starts with "MSBuild.Sdk", that should cover more Sdks

[arturcic]

I have actually checked - https://github.com/microsoft/DacFx/tree/main/src/Microsoft.Build.Sql copilot was correct the one that you mentioned https://github.com/rr-wfm/MSBuild.Sdk.SqlProj is not Microsoft supported meaning we will not support that as well

[aidanblacklumeris]

OK that's weird. I thought I had the official MS tooling installed. I have uninstalled the MSBuild.Sdk.SqlProj template and added the official one - hopefully everything builds! Thanks again.