[BUG] SQL Projects publishing broken in 9.3 during integration testing

[sschutten]

Describe the bug

SQL Server Database project package not found at path C:\Code\xxx\bin\Release\netstandard2.1\xxx.dacpac.

Regression

No response

Steps to reproduce

1. Create an integration test using the `DistributedApplicationTestingBuilder` for any sample with a number of SQL Projects. (see [Write your first .NET Aspire test](https://learn.microsoft.com/en-us/dotnet/aspire/testing/write-your-first-test?pivots=xunit))
2. Execute the test

Expected behavior

My VS is running in Debug mode, so the extension should look for files in the Debug folder.

Screenshots

No response

IDE and version

VS 2022

IDE version

17.13.3

Nuget packages

CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects (9.3.0)

Additional context

This is related to #506 which was fixed with #519. That fixed it by looking at the entry assembly. When Aspire is run via the test runner, my assumption is that the test runner becomes the entry assembly, which is build in release mode.

Help us help you

No, just wanted to report this

[ErikEJ]

@sschutten Any thoughts about how this could be fixed?

[sschutten]

@ErikEJ I've been looking at the code. One idea I have is to use the IDistributedApplicationBuilder.AppHostAssembly for looking for the AssemblyConfigurationAttribute instead of the Assembly.GetEntryAssembly().

I'm currently trying to setup a dev environment to work on it myself, but I'm very new to the Aspire hosting model, so it may take me a while 😊