Entity-framework – The term ‘Update-Database’ is not recognized as the name of a cmdlet

ef-code-firstentity-frameworkentity-framework-5entity-framework-migrations

I am using EF5 beta1 and while I was able to run the "Update-Database" before. Now that I shut down Visual Studio, I cannot get it to run. I get the following error:

The term 'Update-Database' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:16
+ Update-Database <<<< -verbose
+ CategoryInfo : ObjectNotFound: (Update-Database:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException

I have tried to re-install EF5b1 and while was successful (already installed), the 'Update-Database' still does not work.

Can anyone help???

Best Answer

I've been having this problem a number of times lately. I found the solution that worked was to close the Package Manager Console, close Visual Studio and then reopen them. Rebooting also worked most of the time, but not always.

Related Solutions

Azure – The term ‘Enable-Migrations’ is not recognized as the name of a cmdlet, function, script file, or operable program

Try to restart Visual Studio. It helped in my case.

Entity-framework – The term ‘scaffold-dbcontext’ is not recognized as the name of a cmdlet, function, script file, or operable program

For me apparently it worked once I have also ran in Package Manager console :

 Install-Package Microsoft.EntityFrameworkCore.Tools

Also make sure :

To have other dependencies (for example Microsoft.EntityFrameworkCore, Microsoft.EntityFrameworkCore.SqlServer, Microsoft.EntityFrameworkCore.SqlServer.Design...) referenced depending of your needs.
To select the right assembly as target for your commands in the top-right corner of the PM console (I am frequently fooled by forgetting it...)

Another problem I encountered : with the dbcontext located in a separate class library, I was encountering the following error :

Unable to find provider assembly with name Microsoft.EntityFrameworkCore.SqlServer. Ensure the specified name is correct and is referenced by the project.

Which I was able to fix by setting my class library as Startup project in VS (don't ask why as it seems meaningless, but it worked).

Late edit, there's something else to know : You can't run Scaffold-DbContext against a class library targetting only .Net Standard, you must also enable netcoreapp in it, or Scaffold-DbContext will complain. To support both targets, edit the csproj to put : <TargetFrameworks>netcoreapp2.2;netstandard2.0</TargetFrameworks> Instead of <TargetFramework> section.

After all these you'll be able to run your Scaffold-DbContext command line with proper arguments and connection string.

Best Answer

Related Solutions

Azure – The term ‘Enable-Migrations’ is not recognized as the name of a cmdlet, function, script file, or operable program

Entity-framework – The term ‘scaffold-dbcontext’ is not recognized as the name of a cmdlet, function, script file, or operable program

Related Topic