Why am I getting:"Option 'SINGLE_USER' cannot be set in database 'master'." when running my backend c#?

Viewed 480

When I'm trying to run my backend application in C# that allows users to login and register accounts I'm getting the following error:

 Microsoft.EntityFrameworkCore.Database.Command: Error: Failed executing DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='60']
    IF SERVERPROPERTY('EngineEdition') <> 5
    BEGIN
        ALTER DATABASE [master] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    END;
    fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
          Failed executing DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='60']
          IF SERVERPROPERTY('EngineEdition') <> 5
          BEGIN
              ALTER DATABASE [master] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
          END;
    Exception thrown: 'Microsoft.Data.SqlClient.SqlException' in Microsoft.EntityFrameworkCore.Relational.dll
    Exception thrown: 'System.AggregateException' in System.Private.CoreLib.dll
0 Answers
Related