WithExplicitStart has no effect with AddSqlProject

[paulirwin]

Describe the bug

The SQL Server Database Project support is great, but I don't usually need to publish every single time I launch the AppHost. I tried adding WithExplicitStart but it still publishes on launch. I would expect WithExplicitStart (as the documentation and name imply) to mean that it will not publish on AppHost launch, but would give me a "start" button to deploy the project manually.

Regression

No response

Steps to reproduce

Example registration in app host:
#
builder.AddSqlProject<Projects.MyDatabaseProject>("sqlproj")
    .WithReference(db)
    .WithExplicitStart();


1. Add `WithExplicitStart` to the registration like above.
2. Launch the app host.
3. Notice that the SQL project resource immediately goes into Publishing mode.

Expected behavior

The project does not publish on App Host launch, and can be started manually from the Aspire dashboard.

Screenshots

No response

IDE and version

Rider

IDE version

2024.3.7

Nuget packages

CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects (9.3.0)
Aspire.Hosting.SqlServer (9.2.0)
Aspire.Hosting.AppHost (9.2.0)

Additional context

No response

Help us help you

No, just wanted to report this

[paulirwin]

I have a proof of concept of what a fix for this could look like in a feature branch in my fork, but did not want to PR this yet as the issue has not yet been approved: paulirwin@3cb93dd

[ErikEJ]

Feel free to create a PR

@jmezach FYI

[jmezach]

@paulirwin This would be a great addition. Looking forward to a PR :).

[ErikEJ]

@paulirwin Would you like help with this, have other users asking for it?

[ErikEJ]

@jmezach @paulirwin I will have a look at this

[ErikEJ]

@paulirwin In latest preview (soon)

[paulirwin]

Awesome, thank you! My apologies for not being able to do the PR.