No migration possible on EFCore 3.1 for .Net Framework 4.8

[T1m0th33]

Hello,

I am using the latest version of EFCore compatible with .Net Standard 2.0 (the version 3.1.30) as my project is using the .Net Framework 4.8.
When adding a migration to my project, I am getting the following error message:

System.MissingMethodException: Constructor on type 'Microsoft.EntityFrameworkCore.Design.OperationExecutor' not found.
   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.Activator.CreateInstance(String assemblyString, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(String assemblyName, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.AppDomain.CreateInstance(String assemblyName, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.AppDomain.CreateInstanceAndUnwrap(String assemblyName, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.AppDomain.CreateInstanceAndUnwrap(String assemblyName, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at Microsoft.EntityFrameworkCore.Tools.AppDomainOperationExecutor..ctor(String assembly, String startupAssembly, String projectDir, String dataDirectory, String rootNamespace, String language)
   at Microsoft.EntityFrameworkCore.Tools.Commands.ProjectCommandBase.CreateExecutor()
   at Microsoft.EntityFrameworkCore.Tools.Commands.MigrationsAddCommand.Execute()
   at Microsoft.DotNet.Cli.CommandLine.CommandLineApplication.Execute(String[] args)
   at Microsoft.EntityFrameworkCore.Tools.Program.Main(String[] args)
Constructor on type 'Microsoft.EntityFrameworkCore.Design.OperationExecutor' not found.

This looks similar to the issue describe here, in the version 3.0.0 and which has been fixed in this version.

[ajcvickers]

@T1m0th33 Please post your csproj file and the --verbose output from running the command.

[T1m0th33]

ConsoleApp1.zip
In the package manager, executing the command line dotnet ef migrations add xxx --project ConsoleApp1 --verbose is displaying the following error:

Using project 'ConsoleApp1\ConsoleApp1.csproj'.
Using startup project 'ConsoleApp1\ConsoleApp1.csproj'.
Writing 'ConsoleApp1\obj\ConsoleApp1.csproj.EntityFrameworkCore.targets'...
dotnet msbuild /target:GetEFProjectMetadata "/property:EFProjectMetadataFile=C:\Users\XXX\AppData\Local\Temp\tmpED63.tmp" /verbosity:quiet /nologo ConsoleApp1\ConsoleApp1.csproj
Writing 'ConsoleApp1\obj\ConsoleApp1.csproj.EntityFrameworkCore.targets'...
dotnet msbuild /target:GetEFProjectMetadata "/property:EFProjectMetadataFile=C:\Users\XXX\AppData\Local\Temp\tmpF17B.tmp" /verbosity:quiet /nologo ConsoleApp1\ConsoleApp1.csproj
dotnet build ConsoleApp1\ConsoleApp1.csproj /verbosity:quiet /nologo

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

Time Elapsed 00:00:01.84
C:\Users\XXX\.dotnet\tools\.store\dotnet-ef\3.0.0\dotnet-ef\3.0.0\tools\netcoreapp3.0\any\tools\net461\win-x86\ef.exe migrations add xxx --assembly "C:\Users\XXX\source\repos\ConsoleApp1\ConsoleApp1\bin\Debug\net48\ConsoleApp1.exe" --startup-assembly "C:\Users\XXX\source\repos\ConsoleApp1\ConsoleApp1\bin\Debug\net48\ConsoleApp1.exe" --project-dir "C:\Users\XXX\source\repos\ConsoleApp1\ConsoleApp1\\" --language C# --working-dir "C:\Users\XXX\source\repos\ConsoleApp1" --verbose --root-namespace ConsoleApp1
Using assembly 'ConsoleApp1'.
Using startup assembly 'ConsoleApp1'.
Using application base 'C:\Users\XXX\source\repos\ConsoleApp1\ConsoleApp1\bin\Debug\net48'.
Using working directory 'C:\Users\XXX\source\repos\ConsoleApp1\ConsoleApp1'.
Using root namespace 'ConsoleApp1'.
Using project directory 'C:\Users\XXX\source\repos\ConsoleApp1\ConsoleApp1\'.
Using configuration file 'C:\Users\XXX\source\repos\ConsoleApp1\ConsoleApp1\bin\Debug\net48\ConsoleApp1.exe.config'.
System.MissingMethodException: Constructor on type 'Microsoft.EntityFrameworkCore.Design.OperationExecutor' not found.
   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.Activator.CreateInstance(String assemblyString, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(String assemblyName, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.AppDomain.CreateInstance(String assemblyName, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.AppDomain.CreateInstanceAndUnwrap(String assemblyName, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.AppDomain.CreateInstanceAndUnwrap(String assemblyName, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at Microsoft.EntityFrameworkCore.Tools.AppDomainOperationExecutor..ctor(String assembly, String startupAssembly, String projectDir, String dataDirectory, String rootNamespace, String language)
   at Microsoft.EntityFrameworkCore.Tools.Commands.ProjectCommandBase.CreateExecutor()
   at Microsoft.EntityFrameworkCore.Tools.Commands.MigrationsAddCommand.Execute()
   at Microsoft.EntityFrameworkCore.Tools.Commands.CommandBase.<>c__DisplayClass0_0.<Configure>b__0()
   at Microsoft.DotNet.Cli.CommandLine.CommandLineApplication.Execute(String[] args)
   at Microsoft.EntityFrameworkCore.Tools.Program.Main(String[] args)
Constructor on type 'Microsoft.EntityFrameworkCore.Design.OperationExecutor' not found.

[roji]

@T1m0th33 can you also please post the output of dotnet tool list -g?

[T1m0th33]

@roji, here it is:

PM> dotnet tool list -g
Package Id      Version      Commands 
--------------------------------------
dotnet-ef       3.0.0        dotnet-ef

[roji]

To be on the safe side, can you try upgrading your dotnet-ef tool to the latest 3.1.30, so that it corresponds with the version of EF you're using?

[T1m0th33]

@roji, it seems to work, thanks.

PM> dotnet tool update -g dotnet-ef --version 3.1.30
Tool 'dotnet-ef' was successfully updated from version '3.0.0' to version '3.1.30'.
PM> dotnet ef migrations add xxx --project ConsoleApp1
Build started...
Build succeeded.
Unable to create an object of type 'DatabaseContext'. For the different patterns supported at design time, see https://go.microsoft.com/fwlink/?linkid=851728