Support UseArtifactsOutput in .NET 8

[benjamin-hodgson]

I have a repository with two files: a Directory.Build.props with an opt-in for the new UseArtifactsOutput feature in .NET 8,

<!-- Directory.Build.props -->

<Project>
    <PropertyGroup>
        <UseArtifactsOutput>true</UseArtifactsOutput>
    </PropertyGroup>
</Project>

and a sqlproj file in a subfolder:

<!-- MyDb/MyDb.sqlproj -->
<Project Sdk="Microsoft.Build.Sql/0.1.15-preview">
    <PropertyGroup>
        <Name>MyDb</Name>
        <DSP>Microsoft.Data.Tools.Schema.Sql.Sql160DatabaseSchemaProvider</DSP>
        <ModelCollation>1033, CI</ModelCollation>
    </PropertyGroup>
</Project>

When I build the sqlproj (using dotnet build MyDb), the output dacpac goes into the old-style output location, MyDb/bin/Debug/MyDb.dacpac. It should go into the artifacts folder (ie artifacts/bin/MyDb/Debug/MyDb.dacpac) instead.

Thanks!