I want to scaffold an existing database in Core, and I can use the Package Manager Console (or dotnet) with:
scaffold-dbcontext -connection "Server=.\myserver;Database=mydatabase;
User ID=johnny;Password=johnny;Integrated Security=true;"
-provider Microsoft.EntityFrameworkCore.SqlServer -context MyNewDbContext
Is there a way to do this through the IDE without the command line? There is a right-click add for everything else, but I cannot find anything to create a new DbContext so that I can scaffold with the VS add scaffolding right-click add menus. I do not mind typing. I wanted to see if it was required to use the Command Line.
Also, is it possible to reference the connection in appsettings.json instead of using the entire connection string (e.g. ".\sqlserver;...")
There is no context generator for .NET Core using the VS2017 IDE that I can find.
You can use my free EF Core Power Tools extension!