Entity Framework Guides & Tutorials

Practical, hands-on guides to reverse engineering your database into Entity Framework - from database-first basics to generating clean, customisable POCO classes, a DbContext and mappings.

How to Reverse Engineer a SQL Server Database into Entity Framework Core

A step-by-step guide to database-first development in EF Core: what reverse engineering means, using Scaffold-DbContext, its limitations, and how to generate cleaner, fully customisable code with the EntityFramework Reverse POCO Generator.

How to Scaffold Specific Tables in EF Core for a Faster DbContext

Why a large DbContext is slow to start (a real 500-table vs 4-table benchmark), and how to scaffold only the tables you need - filtering tables, views and columns to generate a lean, fast context per microservice.

How to Call SQL Server Stored Procedures in Entity Framework Core

Why Scaffold-DbContext ignores stored procedures and where the built-in FromSqlRaw APIs stop - and how to generate strongly-typed stored procedure methods and result classes automatically.

How to Unit Test Entity Framework Core Without a Database

Why mocking a DbContext and the EF Core InMemory provider fall short, and how a generated FakeDbContext gives you fast, dependency-free unit tests with no mocking.