DotNet Entity Framework Core - Code First Approach Sample

In this approach, we model our entities and database context. Then either using Migrations or DB Initializer, we create the database.

Language : C#
.Net Version : >=6.0

Pre-Requisites

• Visual Studio IDE
• Microsoft SQL Server
• Azure Data Studio / SQL Server Management Studio (SSMS) / SSDT for Visual Studio
  

Scenario

• Database with tables:
  • Departments (Departments data like Name, IsActive)
  • Employees (Employee data like Name, Email, Phone, DepartmentId, IsActive)
  • Skills (Skills data like Name, IsActive)
  • EmployeeSkills (Relation Mapping between Employee and Skill)
• Each Employee belongs to a department and can have multiple skills.

Execution & Implementation Steps

MVC Sample - DotNet MVC Entity Framework Core

Razor Pages Sample - DotNet Razor Pages Entity Framework Core

References

EntityFrameworkCore
.Net Core MVC
.Net Core Razor Pages
EFCore - Get Started
EFCore - MVC
EF Core - Razor Pages
EF - Code First

🔥 Happy Coding