Add support for existing publish profiles

[brettpostin]

Related to an existing integration?

Yes

Existing integration

CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects

Overview

I'm not sure if this is already possible, but it would be good if an existing publish profile could be used instead of setting all config using WithConfigureDacDeployOptions.

I have a publish profile with all desired deployment config for local development when deploying the sqlproj directly in SSDT. I want to avoid having to duplicate and keep that config in sync in Aspire.

Usage example

builder.AddSqlProject<Projects.My_Database>("dacpac-deployment")
.WithProfile(name/path)
.WithReference(sql)
.WaitFor(sql);

Breaking change?

No

Alternatives

N/A

Additional context

No response

Help us help you

No, just wanted to propose this

[github-actions]

We have noticed this issue has not been updated within 21 days. If there is no action on this issue in the next 14 days, we will automatically close it. You can use /stale-extend to extend the window.

[ErikEJ]

/stale-extend

[ErikEJ]

@jmezach Do you think this would add value?

[jmezach]

I guess I can see a use case for it yes 👍

[ErikEJ]

Proposal:

.WithDacDeployOptions(string optionsPath)

If they are set, WithDacConfigureOptions are ignored