Add ability to publish SQL Database Projects to existing SQL server

[ErikEJ]

Related to an existing integration?

Yes

Existing integration

CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects

Overview

According to the docs, you should use AddConnectionString to connect to an existing SQL Server instance

This prevents SQL project publishing from working, as .WithReference only accepts IResourceBuilder<SqlServerDatabaseResource> and AddConnectionString returns IResourceBuilder<IResourceWithConnectionString>

Unsure how to solve, maybe add an WithReference overload that accepts a IResourceBuilder<IResourceWithConnectionString> ?

Happy to do a PR once we agree on a design (and agree that this add value / makes sense)

@jmezach FYI

Usage example

var builder = DistributedApplication.CreateBuilder(args);

var connection = builder.AddConnectionString("Default");

builder.AddSqlProject<Projects.SdkProject>("sdk-project")
       .WithReference(connection);

Breaking change?

No

Alternatives

I seem to be forced to use a SQL container at the moment

Additional context

No response

Help us help you

Yes, I'd like to be assigned to work on this item