Aspire Project update to MSSQL Database

[Ghadawi]

How can we convert this from postgres to MSSQL database in Aspire project?

var database = builder.AddPostgres("db", username, password, port: 5432)
.WithDataVolume()
.AddDatabase("fullstackhero");

var api = builder.AddProject<Projects.Server>("webapi")
.WaitFor(database);

[danieltharris]

The Aspire documentation for SQL Server integration will help:

https://aspire.dev/integrations/databases/sql-server/sql-server-host/#add-sql-server-resource-and-database-resource

Something like:

var sql = builder.AddSqlServer("sql").WithDataVolume();
                                       
var database = sql.AddDatabase("fullstackhero");

What have you tried so far?

[iammukeshm]

Closing as answered. @danieltharris's comment is correct — builder.AddSqlServer("sql").AddDatabase("fullstackhero") is the Aspire integration. You can see the matching Postgres pattern in the current src/Host/FSH.Starter.AppHost/AppHost.cs and swap the resource type to SQL Server.

Note: the broader "first-class SQL Server support" gap (MSSQL migrations project, jsonb ↔ nvarchar(max) mapping, conditional AppHost branching) is tracked separately in #1149 — that one stays open.

Triage notes: docs/ISSUE_TRIAGE_2026-05-14.md.