Trying to set-up Entity Framework core in .Net Standard project
Solution 1:
Startup project 'projectName' targets framework '.NETStandard'. There is no runtime associated with this framework, and projects targeting it cannot be executed directly. To use the Entity Framework Core Package Manager Console Tools with this project, add an executable project targeting .NET Framework or .NET Core that references this project, and set it as the startup project; or, update this project to cross-target .NET Framework or .NET Core.
The error message means this: There is no such thing as an executable .NET Standard project. There is no runtime for it because it is simply a type-forwarding mechanism for multiple different runtimes.
In programming terms, it is a bit like trying to instantiate an interface. You can't do it because there is no implementation to run.
The solution is to pick an executable platform for your application to run on. You can reference as many .NET Standard libraries as you like from your executable (as long as they are compatible with your runtime), but the executable itself cannot be run on .NET Standard. It must target a platform such as .NET Framework or .NET Core in order to execute.
In other words, in order to use a command to scaffold your database, you have to target a runtime. So you will either need to run this command while targeting your main executable project or add a new executable project to your solution to run it on.
You can do this running your command on the CLI with the option --startup-project=[Path_to_your_main_Project]
Solution 2:
Right-clicking the .NET Core app in your project
Clicking Set as StartUp Project
Solution 3:
You can run dotnet ef migrations against .NET Standard projects by creating a .NET Core project, adding your .NET Standard project as a reference, then using the --project and --startup-project to specify which project to run the migrations against.
dotnet ef migrations add MyNewMigrationName --project [pathToNetStandardProject] --startup-project [pathToNetCoreProject]
Solution 4:
I'm actually trying to do this also. I got the scaffolding but Net Standard doesn't seem to load the extensions for table properties.
Make sure you install the EntityFrameworkCore.Tools package for EF. You only need 4.6.1 support which is the default. If I figure out how to fix the extensions issue I'll post here.
These two are required:
Install-Package Microsoft.EntityFrameworkCore.SqlServer
Install-Package Microsoft.EntityFrameworkCore.Tools
Solution 5:
The issue here is this particular line in your .csproj file
<TargetFramework>netstandard2.0</TargetFramework>change it to
<TargetFramework>netcoreapp2.1</TargetFramework>or whatever the version of .net core your main project is targetting, It worked for me, it should work for you too!! :)