SqlServer container rebuilt every run using WithDockerfile(..) and .WithLifetime(ContainerLifetime.Persistent)

[MiniGuinea]

I have a similiar issue to this (#6928) where my SqlServer container isn't destroyed when I stop AppHost but when I restart AppHost a new docker image gets created and the container is destroyed and recreated.

This is the code I use to create the container

var sql= builder.AddSqlServer("sql-server", port: XXXX, password: XXXXXXXX) 
    .WithContainerName("Sql")
    .WithDockerfile("sql-server")
    .WithImageTag("latest") 
    .WithHealthCheck("SqlCheck")
    .WithDataVolume("sql-data")
    .WithLifetime(ContainerLifetime.Persistent)
    .AddDatabase("Sql", "DatabaseName");

builder.Services.AddHealthChecks()
    .AddSqlServer(
        "XXX Sql health check query XXX",
        failureStatus: HealthStatus.Degraded,
        tags: ["db", "sql", "sqlserver"]
    ); 

I am able to get my data persisting between runs by using .WithDataVolume("sql-data") but my app takes a significant time to start up because the container keeps getting thrown away at the beginning of each run.

The docker file is used to deploy a .bacpac to SqlServer when the container starts up to set up the database (following steps from here #5530)

I am running Docker Desktop 4.39.0 and .net SDK 9.0.201

Any help would be appreciated thanks.

[davidfowl]

cc @danegsta