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"));
});