[Breaking change]: Change the default SKU used for creating a new Azure SQL database

[yorek]

Description

The default SKU used for creating a new Azure SQL database during the deployment is GP_S_Gen5_2 (General Purpose Serveless) with the Free Offer enabled (https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql)

Version

.NET Aspire 9.0 GA

Previous behavior

Azure SQL DB was deployed with the default option which was not taking advantage of the free offer

New behavior

Azure SQL DB is deployed using the advantage of the free offer GP_S_Gen5_2 (General Purpose Serveless) with the Free Offer enabled.
The database will be paused if/when the free offer limits are reached to avoid incurring in unexpected monthly costs

Type of breaking change

• Binary incompatible: Existing binaries might encounter a breaking change in behavior, such as failure to load or execute, and if so, require recompilation.
• Source incompatible: When recompiled using the new SDK or component or to target the new runtime, existing source code might require source changes to compile successfully.
• Behavioral change: Existing binaries might behave differently at run time.

Reason for change

Avoid monthly costs by taking advantage of Azure SQL DB free offer: https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql

Recommended action

A new method WithSku as been added to allow developers to choose what SKU to use when deploying the database, as per

• Make it easier to choose Azure SQL SKU aspire#8876
• Set defaults on Sql server instances aspire#8724

Affected APIs

• public class AzureSqlDatabaseResource: updated to use free offer as default deployment option
• public static IResourceBuilder<AzureSqlDatabaseResource> AddDatabase: updated to use free offer as default deployment option
• public static IResourceBuilder<AzureSqlDatabaseResource> WithSku: added to allow to specify the desired sku