After adding aspire project, Failing to deploy sql database project due to MSBuild Exception

[Abdul23061989]

In dotnet solution, we have sql project and api project
I have added dotnet aspire project and want to orchestrate the containers
Issue : failing to deploy sql project due to MSBuild Exception

these are lines of Program.cs in Apphost project

var builder = DistributedApplication.CreateBuilder(args);
//Non-working lines

var sqlServer1 = builder.AddSqlServer("sql").WithLifetime(ContainerLifetime.Persistent).AddDatabase("act");
builder.AddSqlProject<Projects.O_WP_PIT_ACT_Database>("sqlproject").WithReference(sqlServer1).WaitFor(sqlServer1);

//Working lines

var sqlServer2 = builder.AddSqlServer("sql").WithLifetime(ContainerLifetime.Persistent).AddDatabase("act");
builder.AddSqlProject("sqlproject").WithDacpac("O.WP.PIT.ACT.Database.dacpac").WithReference(sqlServer2).WaitFor(sqlServer2);

//api referenced to sqlServer either 1 or 2
var apiService = builder.AddProject<Projects.O_WP_PIT_ACT_API>("apiservice").WithReference(sqlServer);

builder.Build().Run();

this is folder structure of solution

this is the dashboard after running program.cs

this is the consolde logs