A persistent lifetime reuses a SQL Server container instance across runs of an orchestrated application. Without it, each run starts a new container and destroys the old one with its data. This setting supports convenient local database hosting; production guidance favors a managed database, with containers for development and managed instances for production as one hybrid approach. section 3.3
WithLifetime(ContainerLifetime.Persistent)
Set the SQL Server container lifetime to persistent. section 3.3
