- Create empty MVC project.
$ dotnet new mvc -n MyWebProject
For example for sqlite database. All dotnet
commands must be executed under current dotnet project directory.
- add nuget package for EF Core provider for database type (sqlite, mysql, ...)
$ dotnet add package Microsoft.EntityFrameworkCore.Sqlite
- add reference into MyWebProject.csproj for command line tools plugin for entity framework core commands. It's new item under ItemGroup element.
<ItemGroup>
<DotNetCliToolReference Include .... />
<DotNetCliToolReference Include="Microsoft.EntityFrameworkCore.Tools.DotNet" Version="2.0.0" />
</ItemGroup>
- add entity framework core design package and restore project according .csproj changes
$ dotnet add package Microsoft.EntityFrameworkCore.Design
$ dotnet restore
It's necessary to have the correct versions for all these Microsoft.EntityFrameworkCore.* packages
- Generate the models from the current database
$ dotnet ef dbcontext scaffold "Filename=../blog.sqlite" Microsoft.EntityFrameworkCore.Sqlite -o Models