[BUG] New install with an Azure SQL Server database: get "No database provider has been configured for this DbContext" error

[patrickjlee]

Oqtane Info

Version - 10.0.3
Render Mode - Static
Interactivity - Server
Database - Azure SQL Server

Describe the bug

After creating the database in Azure Sql Server, TestOqtane3 and adding an admin user for that database, and running the Oqtane server project (after rebuilding it), the initial set up form appears. After completing it with Azure SQL as Database and Clicking the connection string button and entering a connection string of the form

Server=myservername.database.windows.net;Initial Catalog=TestOqtane3;Persist Security Info=False;User=myusername;password=mypassword;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

and also completing the other fields and clicking "Install Now" I get this error message (which from using breakpoints seems to happen during database migration):

No database provider has been configured for this DbContext. A provider can be configured by overriding the 'DbContext.OnConfiguring' method or by using 'AddDbContext' on the application service provider. If 'AddDbContext' is used, then also ensure that your DbContext type accepts a DbContextOptions object in its constructor and passes it to the base constructor for DbContext.'

Expected Behavior

I expected the database to have its tables populated and the site home page to appear

Steps To Reproduce

See above.

Anything else?

No

[sbwalker]

This will require further investigation. Is this in a local environment or production environment?

[patrickjlee]

Thanks - this is in a test (local) environment, so running the code locally (via running the Oqtane.Server project in debug mode), but pointing to database in SQL Azure.

[sbwalker]

Can you please open the /Content/Log/error.log file and share the full error message which is in the log file (related to not being able to find the DbContext).

In reality the "Azure SQL" database provider is the exact same provider as the SQL Server provider - the only difference is that it has a slightly different UI component for capturing the connection string details. You can verify this by looking in your appsettings.json and scrolling to the "Azure SQL" section:

    {
      "Name": "Azure SQL",
      "ControlType": "Oqtane.Installer.Controls.AzureSqlConfig, Oqtane.Client",
      "DBType": "Oqtane.Database.SqlServer.SqlServerDatabase, Oqtane.Server"
    }

Notice the DBType is SQL Server. My guess is that you are encountering permissions issues when your development environment attempts to connect to Azure - perhaps the log will confirm.

[patrickjlee]

Thanks. The full error message from the log file is:

[2025-12-30 15:21:36+00:00] [Error] [Oqtane.Infrastructure.DatabaseManager] An Error Occurred Provisioning The Master Database. This Is Usually Related To The Master Database Not Being In A Supported State. System.InvalidOperationException: No database provider has been configured for this DbContext. A provider can be configured by overriding the 'DbContext.OnConfiguring' method or by using 'AddDbContext' on the application service provider. If 'AddDbContext' is used, then also ensure that your DbContext type accepts a DbContextOptions object in its constructor and passes it to the base constructor for DbContext.
at Microsoft.EntityFrameworkCore.Internal.DbContextServices.Initialize(IServiceProvider scopedProvider, DbContextOptions contextOptions, DbContext context)
at Microsoft.EntityFrameworkCore.DbContext.get_ContextServices()
at Microsoft.EntityFrameworkCore.DbContext.get_InternalServiceProvider()
at Microsoft.EntityFrameworkCore.DbContext.Microsoft.EntityFrameworkCore.Infrastructure.IInfrastructure<System.IServiceProvider>.get_Instance()
at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.Microsoft.EntityFrameworkCore.Infrastructure.IInfrastructure<System.IServiceProvider>.get_Instance()
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.GetRelationalService[TService](IInfrastructure`1 databaseFacade)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.Migrate(DatabaseFacade databaseFacade)
at Oqtane.Infrastructure.DatabaseManager.MigrateMaster(InstallConfig install) in C:\Users\patri\Dropbox\Devs\InQAGroup\oqtane.framework-10.0.3\Oqtane.Server\Infrastructure\DatabaseManager.cs:line 293