Why can't my generic Blazor app read the LocalDb for Identity?

Question

I wanted to see how a new Blazor Web app uses the LocalDb that is created when you create a new application that uses Individual Accounts during the project creation process. In my AppSettings.json file it created this connection string:

"ConnectionStrings": {
    "DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=aspnet-BlazorWebWithIdentity-5435ed71-e6f7-4a07-bf75-3acd150ee815;Trusted_Connection=True;MultipleActiveResultSets=true"
  }

Then later in the Program.cs file I put in this:

var connectionString = builder.Configuration.GetConnectionString("DefaultConnection") ?? throw new InvalidOperationException("Connection string 'DefaultConnection' not found.");
builder.Services.AddDbContext<ApplicationDbContext>(options =>
    options.UseSqlServer(connectionString, sqlOptions =>
    {
        sqlOptions.EnableRetryOnFailure(
            maxRetryCount: 5,
            maxRetryDelay: TimeSpan.FromSeconds(30),
            errorNumbersToAdd: null);
    }));

However, when I debug the app, I get this error when I try to create a login:

at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsyncTState,TResult ClientConnectionId:62785e65-5c0f-4c3e-a8b3-63523fca0e45 Error Number:4060,State:1,Class:11 --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsyncTState,TResult at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsyncTState,TResult at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() Exception thrown: 'Microsoft.EntityFrameworkCore.Storage.RetryLimitExceededException' in System.Private.CoreLib.dll An exception of type 'Microsoft.EntityFrameworkCore.Storage.RetryLimitExceededException' occurred in System.Private.CoreLib.dll but was not handled in user code The maximum number of retries (5) was exceeded while executing database operations with 'SqlServerRetryingExecutionStrategy'. See the inner exception for the most recent failure.

I'm using .NET 9

Answer 1

If this is the first time for you to create a local database to test Identity, you might need to make sure that database has been created. If you didn't do anything to create the database, you might take a look at this section, I mean you might run Update-Database in Package Manager Console window

Here's my test result, I create a new .net 9 blazor web app auto-rendered mode, and after I run the app the try to register a user, I got error message below, which indicating that I'm not able to connect to the database, but the truth is that I haven't created this database yet. But since we didn't see the inner exception you shared, I'm not sure whether we are facing the same issue.

If you do face the same issue as mine, if you press F5 to continue the app, you might see screenshot below which suggestion you to run update database command.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best regards,

Tiny

Answer 2

since the database is one that is included as a part of the Visual Studio project template, to create Identity tables (when I chose Individual Accounts) I don't know what more it is that I have to do, in order to create the database.

As far as I can tell and after several recommendations you finally ran update-database in the Program Manager Console. You did not report any errors after executing update-database so I'm guessing the Identity database was created.

Reference documentation

https://learn.microsoft.com/en-us/aspnet/core/security/authentication/identity?view=aspnetcore-9.0&tabs=visual-studio

Is there something that I need to install? And if so, what?

The Visual Studio installs a development version of SQL Server; (localdb)\mssqllocaldb. You should not have to install anything, other than Visual Studio, to work with data. Have you tried connecting to the database using the tooling in Visual Studio (SQL Server Object Explorer) as suggested above? You can also use SQL management studio.

At this point, you should be able to register an account in your application. Have you tried running the Blazor application and registering?

If you are still having problems and want help then we, the community, need the steps you are performing and any error messages you encounter along the way. That will help us help you.