Build a .NET 10 Web API with Minimal APIs, Entity Framework Core and SQL Server, using Clean Architecture and FluentValidation.
Learn how keyset pagination works in Entity Framework Core, how it compares to offset pagination, and how indexes can dramatically improve your pagination performance.
Learn how to track every change to your EF Core records using SQL Server temporal tables, with examples for querying the history.
Learn how to build a reusable PagedResults class in .NET that works with Entity Framework Core and supports multiple entity types.
Learn why EF Core without migrations is a disaster. Learn how to setup, configure, and deploy using migrations to keep databases consistent across environments.
Learn how to use transactions in Entity Framework Core to ensure multiple database operations either all succeed or all roll back, keeping your data consistent.
Discover how EF Core query filters enforce global rules, simplify multitenancy, and clean up queries to stop sensitive data leaking into production.
Learn how to use the new LeftJoin and RightJoin LINQ methods introduced in EF Core for .NET 10, replacing the verbose GroupJoin and SelectMany pattern.
Learn how to add request logging to a database in an ASP.NET Core Web API using Entity Framework Core to effectively monitor and analyse API traffic.
Learn how to create a ValueConverter in Entity Framework Core to save dates as UTC in the database & convert them back to your local time zone in ASP.NET Core.