Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ASPNETCORE_ENVIRONMENT does not default to Development when using EF Core 9 if there is a IDesignTimeDbContextFactory implementation #35174

Closed
Pilchard123 opened this issue Nov 21, 2024 · 0 comments
Closed

ASPNETCORE_ENVIRONMENT does not default to Development when using EF Core 9 if there is a IDesignTimeDbContextFactory implementation #35174

Pilchard123 opened this issue Nov 21, 2024 · 0 comments
Labels
area-migrations area-tools closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. customer-reported regression type-bug
Milestone
9.0.1

Comments

@Pilchard123
Copy link

Pilchard123 commented Nov 21, 2024 •
edited
Loading

Running dotnet ef database update while using EF Core 8.0.11 or earlier used to set ASPNETCORE_ENVIRONMENT and DOTNET_ENVIRONMENT to "Development" if it was not explicitly specified. On updating to EF Core 9, those do not default if there is an implementation of IDesignTimeDbContextFactory. The version of dotnet-ef (at least between 9.0.0 and 8.0.11) does not seem to matter.

I believe this is the code in question, though I haven't managed to chase down why it's not being hit for 9.0.0 with IDesignTimeDbContextFactory.

This project can be manipulated to reproduce the issue, though I've also included some relevant tool output from dotnet ef database update --project .\ReproTest\ --verbose below.

My current workaround is to explicitly set the Environment as described at https://learn.microsoft.com/en-us/ef/core/cli/dotnet#aspnet-core-environment .

Provider and version information

EF Core version:
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: .NET 8 and 9
Operating system: Windows 11 23H2, 22631.4460
IDE: Visual Studio 2022 17.12.0

Log output

EF Core 8.0.11, no IDesignTimeDbContextFactory - WORKS

Using project 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj'.
Using startup project 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj'.
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\FakeUserProfiles\richard.ward\temp\tmpwotm5q.tmp /verbosity:quiet /nologo C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\FakeUserProfiles\richard.ward\temp\tmpg2k1nh.tmp /verbosity:quiet /nologo C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj
Build started...
dotnet build C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj /verbosity:quiet /nologo /p:PublishAot=false

Build succeeded.
    0 Warning(s)
    0 Error(s)

Time Elapsed 00:00:06.17

Build succeeded.
dotnet exec --depsfile C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.deps.json --additionalprobingpath C:\FakeUserProfiles\richard.ward\nuget --additionalprobingpath "C:\Program Files (x86)\Microsoft Visual Studio\Shared\NuGetPackages" --runtimeconfig C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.runtimeconfig.json C:\FakeUserProfiles\richard.ward\nuget\dotnet-ef\9.0.0\tools\net8.0\any\tools\netcoreapp2.0\any\ef.dll database update --assembly C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.dll --project C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj --startup-assembly C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.dll --startup-project C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj --project-dir C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ --root-namespace ReproTest --language C# --framework net9.0 --nullable --working-dir C:\FakeUserProfiles\richard.ward\repos\Test --verbose
Using assembly 'ReproTest'.
Using startup assembly 'ReproTest'.
Using application base 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0'.
Using working directory 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest'.
Using root namespace 'ReproTest'.
Using project directory 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\'.
Remaining arguments: .
Finding DbContext classes...
Finding IDesignTimeDbContextFactory implementations...
Finding application service provider in assembly 'ReproTest'...
Finding Microsoft.Extensions.Hosting service provider...
Using environment 'Development'.
Using application service provider from Microsoft.Extensions.Hosting.
Found DbContext 'TestDbContext'.
Finding DbContext classes in the project...
Using context 'TestDbContext'.
Finding design-time services referenced by assembly 'ReproTest'...
Finding design-time services referenced by assembly 'ReproTest'...
No referenced design-time services were found.
Finding design-time services for provider 'Microsoft.EntityFrameworkCore.SqlServer'...
Using design-time services from provider 'Microsoft.EntityFrameworkCore.SqlServer'.
Finding IDesignTimeServices implementations in assembly 'ReproTest'...
No design-time services were found.
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (23ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT 1
Executed DbCommand (23ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (18ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
Executed DbCommand (18ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT 1
Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [MigrationId], [ProductVersion]
      FROM [__EFMigrationsHistory]
      ORDER BY [MigrationId];
Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId];
info: Microsoft.EntityFrameworkCore.Migrations[20405]
      No migrations were applied. The database is already up to date.
No migrations were applied. The database is already up to date.
Done.

EF Core 8.0.11, with IDesignTimeDbContextFactory - WORKS

Using project 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj'.
Using startup project 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj'.
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\FakeUserProfiles\richard.ward\temp\tmpl42vyr.tmp /verbosity:quiet /nologo C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\FakeUserProfiles\richard.ward\temp\tmpyp4ywh.tmp /verbosity:quiet /nologo C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj
Build started...
dotnet build C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj /verbosity:quiet /nologo /p:PublishAot=false

Build succeeded.
    0 Warning(s)
    0 Error(s)

Time Elapsed 00:00:05.10

Build succeeded.
dotnet exec --depsfile C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.deps.json --additionalprobingpath C:\FakeUserProfiles\richard.ward\nuget --additionalprobingpath "C:\Program Files (x86)\Microsoft Visual Studio\Shared\NuGetPackages" --runtimeconfig C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.runtimeconfig.json C:\FakeUserProfiles\richard.ward\nuget\dotnet-ef\9.0.0\tools\net8.0\any\tools\netcoreapp2.0\any\ef.dll database update --assembly C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.dll --project C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj --startup-assembly C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.dll --startup-project C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj --project-dir C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ --root-namespace ReproTest --language C# --framework net9.0 --nullable --working-dir C:\FakeUserProfiles\richard.ward\repos\Test --verbose
Using assembly 'ReproTest'.
Using startup assembly 'ReproTest'.
Using application base 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0'.
Using working directory 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest'.
Using root namespace 'ReproTest'.
Using project directory 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\'.
Remaining arguments: .
Finding DbContext classes...
Finding IDesignTimeDbContextFactory implementations...
Found IDesignTimeDbContextFactory implementation 'DesignTimeContextFactory'.
Found DbContext 'TestDbContext'.
Finding application service provider in assembly 'ReproTest'...
Finding Microsoft.Extensions.Hosting service provider...
Using environment 'Development'.
Using application service provider from Microsoft.Extensions.Hosting.
Finding DbContext classes in the project...
Using DbContext factory 'DesignTimeContextFactory'.
Using context 'TestDbContext'.
Finding design-time services referenced by assembly 'ReproTest'...
Finding design-time services referenced by assembly 'ReproTest'...
No referenced design-time services were found.
Finding design-time services for provider 'Microsoft.EntityFrameworkCore.SqlServer'...
Using design-time services from provider 'Microsoft.EntityFrameworkCore.SqlServer'.
Finding IDesignTimeServices implementations in assembly 'ReproTest'...
No design-time services were found.
Creating DbConnection.
Created DbConnection. (50ms).
Migrating using database 'TestDb' on server '(localdb)\mssqllocaldb'.
Opening connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Opened connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Creating DbCommand for 'ExecuteNonQuery'.
Created DbCommand for 'ExecuteNonQuery' (9ms).
Initialized DbCommand for 'ExecuteNonQuery' (17ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
Executed DbCommand (29ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
Closing connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Closed connection to database 'TestDb' on server '(localdb)\mssqllocaldb' (7ms).
Creating DbCommand for 'ExecuteScalar'.
Created DbCommand for 'ExecuteScalar' (2ms).
Initialized DbCommand for 'ExecuteScalar' (4ms).
Opening connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Opened connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
Executed DbCommand (19ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
Closing connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Closed connection to database 'TestDb' on server '(localdb)\mssqllocaldb' (2ms).
Opening connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Opened connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Creating DbCommand for 'ExecuteNonQuery'.
Created DbCommand for 'ExecuteNonQuery' (0ms).
Initialized DbCommand for 'ExecuteNonQuery' (1ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
Closing connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Closed connection to database 'TestDb' on server '(localdb)\mssqllocaldb' (0ms).
Creating DbCommand for 'ExecuteScalar'.
Created DbCommand for 'ExecuteScalar' (0ms).
Initialized DbCommand for 'ExecuteScalar' (1ms).
Opening connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Opened connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
Closing connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Closed connection to database 'TestDb' on server '(localdb)\mssqllocaldb' (1ms).
Opening connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Opened connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Creating DbCommand for 'ExecuteReader'.
Created DbCommand for 'ExecuteReader' (0ms).
Initialized DbCommand for 'ExecuteReader' (1ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId];
Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId];
Closing data reader to 'TestDb' on server '(localdb)\mssqllocaldb'.
A data reader for 'TestDb' on server '(localdb)\mssqllocaldb' is being disposed after spending 4ms reading results.
Closing connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Closed connection to database 'TestDb' on server '(localdb)\mssqllocaldb' (0ms).
No migrations were applied. The database is already up to date.
'TestDbContext' disposed.
Disposing connection to database 'TestDb' on server '(localdb)\mssqllocaldb'.
Disposed connection to database '' on server '' (1ms).
Done.

EF Core 9.0.0, no IDesignTimeDbContextFactory - WORKS

Using project 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj'.
Using startup project 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj'.
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\FakeUserProfiles\richard.ward\temp\tmppuq5sx.tmp /verbosity:quiet /nologo C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\FakeUserProfiles\richard.ward\temp\tmprbhnb1.tmp /verbosity:quiet /nologo C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj
Build started...
dotnet build C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj /verbosity:quiet /nologo /p:PublishAot=false

Build succeeded.
    0 Warning(s)
    0 Error(s)

Time Elapsed 00:00:06.05

Build succeeded.
dotnet exec --depsfile C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.deps.json --additionalprobingpath C:\FakeUserProfiles\richard.ward\nuget --additionalprobingpath "C:\Program Files (x86)\Microsoft Visual Studio\Shared\NuGetPackages" --runtimeconfig C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.runtimeconfig.json C:\FakeUserProfiles\richard.ward\nuget\dotnet-ef\9.0.0\tools\net8.0\any\tools\netcoreapp2.0\any\ef.dll database update --assembly C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.dll --project C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj --startup-assembly C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.dll --startup-project C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj --project-dir C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ --root-namespace ReproTest --language C# --framework net9.0 --nullable --working-dir C:\FakeUserProfiles\richard.ward\repos\Test --verbose
Using assembly 'ReproTest'.
Using startup assembly 'ReproTest'.
Using application base 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0'.
Using working directory 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest'.
Using root namespace 'ReproTest'.
Using project directory 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\'.
Remaining arguments: .
Finding DbContext classes...
Finding IDesignTimeDbContextFactory implementations...
Finding DbContext classes in the project...
Found DbContext 'TestDbContext'.
Finding application service provider in assembly 'ReproTest'...
Finding Microsoft.Extensions.Hosting service provider...
Using environment 'Development'.
Using application service provider from Microsoft.Extensions.Hosting.
Using context 'TestDbContext'.
Finding design-time services referenced by assembly 'ReproTest'...
Finding design-time services referenced by assembly 'ReproTest'...
No referenced design-time services were found.
Finding design-time services for provider 'Microsoft.EntityFrameworkCore.SqlServer'...
Using design-time services from provider 'Microsoft.EntityFrameworkCore.SqlServer'.
Finding IDesignTimeServices implementations in assembly 'ReproTest'...
No design-time services were found.
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (22ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT 1
Executed DbCommand (22ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
info: Microsoft.EntityFrameworkCore.Migrations[20411]
      Acquiring an exclusive lock for migration application. See https://aka.ms/efcore-docs-migrations-lock for more information if this takes too long.
Acquiring an exclusive lock for migration application. See https://aka.ms/efcore-docs-migrations-lock for more information if this takes too long.
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (24ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      DECLARE @result int;
      EXEC @result = sp_getapplock @Resource = '__EFMigrationsLock', @LockOwner = 'Session', @LockMode = 'Exclusive';
      SELECT @result
Executed DbCommand (24ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
DECLARE @result int;
EXEC @result = sp_getapplock @Resource = '__EFMigrationsLock', @LockOwner = 'Session', @LockMode = 'Exclusive';
SELECT @result
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      IF OBJECT_ID(N'[__EFMigrationsHistory]') IS NULL
      BEGIN
          CREATE TABLE [__EFMigrationsHistory] (
              [MigrationId] nvarchar(150) NOT NULL,
              [ProductVersion] nvarchar(32) NOT NULL,
              CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY ([MigrationId])
          );
      END;
Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
IF OBJECT_ID(N'[__EFMigrationsHistory]') IS NULL
BEGIN
    CREATE TABLE [__EFMigrationsHistory] (
        [MigrationId] nvarchar(150) NOT NULL,
        [ProductVersion] nvarchar(32) NOT NULL,
        CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY ([MigrationId])
    );
END;
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT 1
Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [MigrationId], [ProductVersion]
      FROM [__EFMigrationsHistory]
      ORDER BY [MigrationId];
Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId];
No migrations were applied. The database is already up to date.
info: Microsoft.EntityFrameworkCore.Migrations[20405]
      No migrations were applied. The database is already up to date.
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      DECLARE @result int;
      EXEC @result = sp_releaseapplock @Resource = '__EFMigrationsLock', @LockOwner = 'Session';
      SELECT @result
Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
DECLARE @result int;
EXEC @result = sp_releaseapplock @Resource = '__EFMigrationsLock', @LockOwner = 'Session';
SELECT @result
Done.

EF Core 9.0.0, with IDesignTimeDbContextFactory - DOES NOT WORK

Using project 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj'.
Using startup project 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj'.
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\FakeUserProfiles\richard.ward\temp\tmp2r1lqx.tmp /verbosity:quiet /nologo C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\FakeUserProfiles\richard.ward\temp\tmpfn3pxx.tmp /verbosity:quiet /nologo C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj
Build started...
dotnet build C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj /verbosity:quiet /nologo /p:PublishAot=false

Build succeeded.
    0 Warning(s)
    0 Error(s)

Time Elapsed 00:00:04.96

Build succeeded.
dotnet exec --depsfile C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.deps.json --additionalprobingpath C:\FakeUserProfiles\richard.ward\nuget --additionalprobingpath "C:\Program Files (x86)\Microsoft Visual Studio\Shared\NuGetPackages" --runtimeconfig C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.runtimeconfig.json C:\FakeUserProfiles\richard.ward\nuget\dotnet-ef\9.0.0\tools\net8.0\any\tools\netcoreapp2.0\any\ef.dll database update --assembly C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.dll --project C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj --startup-assembly C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0\ReproTest.dll --startup-project C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ReproTest.csproj --project-dir C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\ --root-namespace ReproTest --language C# --framework net9.0 --nullable --working-dir C:\FakeUserProfiles\richard.ward\repos\Test --verbose
Using assembly 'ReproTest'.
Using startup assembly 'ReproTest'.
Using application base 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\bin\Debug\net9.0'.
Using working directory 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest'.
Using root namespace 'ReproTest'.
Using project directory 'C:\FakeUserProfiles\richard.ward\repos\Test\ReproTest\'.
Remaining arguments: .
Finding DbContext classes...
Finding IDesignTimeDbContextFactory implementations...
Found IDesignTimeDbContextFactory implementation 'DesignTimeContextFactory'.
Found DbContext 'TestDbContext'.
Finding DbContext classes in the project...
Using DbContext factory 'DesignTimeContextFactory'.
Using context 'TestDbContext'.
Finding design-time services referenced by assembly 'ReproTest'...
Finding design-time services referenced by assembly 'ReproTest'...
No referenced design-time services were found.
Finding design-time services for provider 'Microsoft.EntityFrameworkCore.SqlServer'...
Using design-time services from provider 'Microsoft.EntityFrameworkCore.SqlServer'.
Finding IDesignTimeServices implementations in assembly 'ReproTest'...
No design-time services were found.
Creating DbConnection.
Created DbConnection. (18ms).
Migrating using database '' on server ''.
Opening connection to database '' on server ''.
An error occurred using the connection to database '' on server ''.
'TestDbContext' disposed.
Disposing connection to database '' on server ''.
Disposed connection to database '' on server '' (4ms).
System.InvalidOperationException: The ConnectionString property has not been initialized.
   at Microsoft.Data.SqlClient.SqlConnection.PermissionDemand()
   at Microsoft.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.OpenDbConnection(Boolean errorsExpected)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.<>c__DisplayClass18_0.<Exists>b__0(DateTime giveUp)
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c__DisplayClass12_0`2.<Execute>b__0(DbContext _, TState s)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func`2 operation, Func`2 verifySucceeded)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.Exists(Boolean retryOnNotExists)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.Exists()
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
   at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
The ConnectionString property has not been initialized.
@AndriySvyryd AndriySvyryd added this to the 9.0.x milestone Nov 22, 2024
AndriySvyryd added a commit that referenced this issue Nov 28, 2024
@AndriySvyryd
Set environment variables to "Development" when creating DbContext us…
317dda2 
…ing IDesignTimeDbContextFactory

Fixes #35174
@AndriySvyryd AndriySvyryd mentioned this issue Nov 28, 2024
Merged
@ajcvickers ajcvickers added the closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. label Dec 2, 2024
@AndriySvyryd AndriySvyryd removed their assignment Dec 2, 2024
@AndriySvyryd AndriySvyryd modified the milestones: 9.0.x, 9.0.1 Dec 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area-migrations area-tools closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. customer-reported regression type-bug
Projects
None yet
Milestone
9.0.1
Development

No branches or pull requests
5 participants
@ajcvickers @maumar @cincuranet @AndriySvyryd @Pilchard123