Aspire.Hosting.Azure.Sql - Deployment of Database Project not working

[ErikEJ]

Is there an existing issue for this?

• I have searched the existing issues

Describe the bug

When using RunAsContainer with SQL Database projects hosting extension, events do not seem to be respected.

var sqlSrv = builder.AddAzureSqlServer("sql")
    .RunAsContainer();    

var sqlDb = sqlSrv.AddDatabase("aspiretodo");

var dbPrj = builder.AddSqlProject<Projects.TodoDB>("tododb")    
    .WithReference(sqlDb);

this code in the SQL database projects extension runs without any waiting:

builder.ApplicationBuilder.Eventing.Subscribe<AfterResourcesCreatedEvent>(async (@event, ct) => {
    await RunPublish(builder, target, targetDatabaseName, @event.Services, ct);
});

If the RunAsContainer method was updated for eventing, I think this would work out of the box with the current implementation

See discussion in the issue here: CommunityToolkit/Aspire#529 (comment)

Expected Behavior

The RunAsContainer method should fire ResourcesCreatedEvent when running.

Steps To Reproduce

No response

Exceptions (if any)

No response

.NET Version info

.NET 8

Anything else?

<PackageReference Include="Aspire.Hosting.AppHost" Version="9.1.0" />
<PackageReference Include="Aspire.Hosting.Azure.Sql" Version="9.1.0" />
<PackageReference Include="Aspire.Hosting.SqlServer" Version="9.1.0" />
<PackageReference Include="CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects" Version="9.2.1" />