AddAzureSqlServer with RunAsContainer tries to provision roles when running locally

[WolfspiritM]

Is there an existing issue for this?

• I have searched the existing issues

Describe the bug

In some cases when using AddAzureSqlServer together with RunAsContainer it tries to provision the sql-roles even so it should only run locally.

Expected Behavior

No "sql-roles" should be published when running locally with "RunAsContainer"

Steps To Reproduce

1. Create starter app template
2. Add the Azure Sql nuget packet
3. Add this to the AppHost builder:

builder.AddBicepTemplateString("test", "");

var sqlServer = builder
    .AddAzureSqlServer("sql")
    .RunAsContainer();
var identityDb = sqlServer.AddDatabase("identityDb");

4. Add a "WithReference(identityDb)" to any of the projects.

Starting the project like this tries to publish sql roles.
This problem disappears if "AddBicepTemplate" or "AddBicepTemplateString" is removed or the reference to the database is removed.

Exceptions (if any)

No response

.NET Version info

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

Anything else?

.NET Aspire version 9.3.0
VS 2022

[danmoseley]

Patched in 9.3.1. To pick up this fix if you need it,

For existing projects targeting 9.3.0, please update as follows;
<Sdk Name="Aspire.AppHost.Sdk" Version="9.3.0" /> to <Sdk Name="Aspire.AppHost.Sdk" Version="9.3.1" /> and
<PackageReference Include="Aspire...." Version="9.3.0" /> to <PackageReference Include="Aspire...." Version="9.3.1" /> and restore packages.

If you're creating new projects, you can just install and use the updated project templates: dotnet new install Aspire.ProjectTemplates::9.3.1 --force