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