Home Entity Framework Scaffold
Post
Cancel

Entity Framework Scaffold

How to add Entity Framework Nuget packages and how to scaffold a database context for a SQL Database.

Nuget Packages

Update

1
Update-Package

Install

Package Manager

1
2
3
4
Install-Package Microsoft.EntityFrameworkCore
Install-Package Microsoft.EntityFrameworkCore.SqlServer
Install-Package Microsoft.EntityFrameworkCore.Tools
Install-Package Microsoft.EntityFrameworkCore.Design

.NET CLI

1
2
3
4
dotnet add package Microsoft.EntityFrameworkCore
dotnet add package Microsoft.EntityFrameworkCore.SqlServer
dotnet add package Microsoft.EntityFrameworkCore.Tools
dotnet add package Microsoft.EntityFrameworkCore.Design

Scaffold (Database First)

Package Manager

1
Scaffold-DbContext "Data Source=localhost;Initial Catalog=[database];Integrated Security=True;TrustServerCertificate=True" Microsoft.EntityFrameworkCore.SqlServer -ContextDir [ContextDir] -Context [ApplicationDbContext] -OutputDir [OutputDir]

App Configuration

ASP .NET Core (+6.x)

1
2
3
4
builder.Services.AddDbContext<ApplicationDbContext>(options =>
{
    options.UseSqlServer(builder.Configuration.GetConnectionString("ConfigContext"));
});
This post is licensed under CC BY 4.0 by the author.