This sample demonstrates how to configure a SQL Server container to use a persistent volume in Aspire, so that the data is persisted across app launches. This method can be used to persist data across instances of other container types configured in Aspire apps too, e.g. PostgreSQL, Redis, etc.

The app consists of a single service, VolumeMount.BlazorWeb, that is configured with a SQL Server container instance via the AppHost project. PostgreSQL and Azure Storage data services are also configured in the AppHost and Blazor projects for demonstration and experimentation purposes. This Blazor Web app has been setup to use ASP.NET Core Identity for local user account registration and authentication, including Blazor identity UI. Using a persistent volume means that user accounts created when running locally are persisted across launches of the app.

The app also includes a class library project, VolumeMount.Data, that contains the Entity Framework Core data model and migrations, a worker service project, VolumeMount.MigrationService, that applies any pending database migrations on startup before the web front end starts, and a standard class library project, VolumeMount.ServiceDefaults, that contains the service defaults used by the service projects.

• Aspire development environment
• .NET 10 SDK

1. If using the Aspire CLI, run aspire run from this directory.

   If using VS Code, open this directory as a workspace and launch the VolumeMount.AppHost project using either the Aspire or C# debuggers.

   If using Visual Studio, open the solution file VolumeMount.slnx and launch/debug the VolumeMount.AppHost project.

   If using the .NET CLI, run dotnet run from the VolumeMount.AppHost directory.

2. Navigate to the URL for the VolumeMount.BlazorWeb from the dashboard.

3. From the home page, click the "Create your account" button (or "Create account" in the top navigation bar) and enter an email and password to create a local user:

   

4. A page will be shown confirming the registration of the account and a message detailing that a real email sender is not registered. Find and click the link at the end of the message to confirm the created account:

   

5. Verify that the email confirmation page is displayed, indicating that the account is now registered and can be used to login to the site, and then click the "Sign in" link in the top navigation bar:

   

6. Enter the email and password you used in the account registration page to login:

   

7. Once logged in, click the "Sign out" button in the top navigation bar to log out of the site, and then stop the app, followed by starting it again, and verifying that the account you just created can still be used to login to the site once restarted, indicating that the database was using the persistent volume to store the data. You can verify the named volume existance using the Docker CLI too (docker volume ls):

   > docker volume ls -f name=sqlserver
   DRIVER    VOLUME NAME
   local     volumemount.apphost-305a028ab1-sqlserver-data