Delete database shard mapping and shard databases in SQL Server to clean up tenant resources

Question

We have a database for each tenant as shown in the screenshot below. I am trying to delete the tenant DB and clean up and reclaim the resources of a tenant I have anciently created. I tried the following code, however, even though this method executes successfully, no changes take place in the database. The tenant database still remains and mappings are still there in [ShardsGlobal] table.

What is the proper way to fully delete tenant-specific databases and references from SQL Server?

Please note that we will be using Azure Elastic Pool in production.

string shardMapManagerConnectionString = configuration.GetShardMapMangerConnectionString();

ShardMapManager shardMapManager;
shardMapManager = ShardMapManagerFactory.GetSqlShardMapManager(
                shardMapManagerConnectionString,
                ShardMapManagerLoadPolicy.Lazy);

var shardMap = shardMapManager.GetListShardMap<T>(configuration.ShardMapName);

if (shardMap.TryGetMappingForKey(key, out PointMapping<T> mapping))
{
    if (mapping.Status == MappingStatus.Online)
    {
        // `mapping =` on next line is needed
        mapping = shardMap.MarkMappingOffline(mapping);
    }

    shardMap.DeleteMapping(mapping);

    var shard = shardMap.GetShard(mapping.Shard.Location);
    shardMap.DeleteShard(shard);
}

Answer 1

If you look at the docs for DeleteShard you'll notice this part:

These methods do not have any impact on the databases themselves, only on metadata in the shard map.

Have you tried the approach presented in the Azure Samples?

To delete both shard and DB, I would assume, based on the FAQ, you'd have to delete the shard first, then the DB.