I recently started using Aspire out of curiosity, and I immediately fell in love with it. Once you’ve grasped the main idea, assembling and provisioning applications becomes a breeze!

I am currently using it to deploy Riverdam, and I will be using it for all my other Azure projects from now on, for sure.

One of the things that took me a bit to figure out was how to select the SKU for a SQL Server instance. It is not super straightforward (at least not as of today), so I figured it was a good idea to write this post in case anyone else is looking for a solution.

Enough talking, let’s get to the code:

var db = builder.AddAzureSqlServer("sql")
        .ConfigureInfrastructure(infra =>
        {
          var resources = infra.GetProvisionableResources();

          var dbRes = resources.OfType<SqlDatabase>().Single();
          dbRes.Sku = new SqlSku()
          {
              Tier = "Basic",
              Name = "Basic",
          };
        }).AddDatabase("MyDatabase");

Luckily it’s not a lot of code, so I guess there’s no real need for an explanation. Enjoy!

Did you like this post? Then