Entity FrameWork Core Database First

1. Installing EntityFrameWordkCore

For visual code


dotnet add package Microsoft.EntityFrameworkCore.SqlServer
dotnet add package Microsoft.EntityFrameworkCore.Design

For visual studio


PM>> Install-Package Microsoft.EntityFrameworkCore.SqlServer
PM>> Install-Package Microsoft.EntityFrameworkCore.Design
PM>> Install-Package Microsoft.EntityFrameworkCore.Tools

Installing tool dotnet-ef


dotnet tool install --global dotnet-ef

Generate class Models

Visual studio


Scaffold-DbContext Name=ConnectionStrings:Phone Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

Visual code


dotnet ef dbcontext scaffold "Server=.;Database=Phone;Trusted_Connection=True;TrustServerCertificate=True;" Microsoft.EntityFrameworkCore.SqlServer -o Models

Generate class Models with ConnectionString


dotnet ef dbcontext scaffold Name=ConnectionStrings:Phone Microsoft.EntityFrameworkCore.SqlServer -o Models