Entity Framework Core Mastery

1. Foundations & Architecture

1 Introduction to Object Relational Mapping (ORM) 8 min 2 Entity Framework Core Architecture & Providers 8 min 3 Setup and DbContext Integration 8 min 4 Code-First vs Database-First Approaches 8 min 5 Reverse Engineering Existing Databases (Scaffolding) 8 min

2. Code-First Modeling

6 Entity Conventions & Data Annotations 8 min 7 The Fluent API Deep Dive (OnModelCreating) 8 min 8 Primary Keys, Composite Keys, & Guids 8 min 9 Required Properties & Database Defaults 8 min 10 Value Conversions (Enums & Strongly Typed IDs) 8 min

3. Relational Architecture

11 One-to-Many Relationships & Foreign Keys 8 min 12 One-to-One Relationships (Dependent Entities) 8 min 13 Many-to-Many Relationships & Navigation Properties 8 min 14 Owned Entity Types (Value Objects) 8 min 15 Table-per-Hierarchy (TPH) Inheritance 8 min

4. Data Querying & LINQ

16 Basic LINQ Queries & IQueryable Execution 8 min 17 Tracking vs No-Tracking Queries (Performance) 8 min 18 Eager Loading vs Explicit Loading (Include) 8 min 19 Lazy Loading Pitfalls & Proxies 8 min 20 Client vs Server Evaluation Parsing 8 min

5. Manipulating Data (CUD)

21 Adding, Updating, and Removing Entities 8 min 22 The ChangeTracker and Entity States 8 min 23 Disconnected Entities in Web APIs 8 min 24 Batch Updates and Deletes (.NET 7+) 8 min

6. Advanced Performance & Scale

25 Concurrency Tokens and Optimistic Locking 8 min 26 Raw SQL Queries and Views (FromSqlRaw) 8 min 27 Compiled Queries for High Throughput 8 min 28 Interceptors (Logging & Auditing Data Changes) 8 min 29 DbContext Pooling Mechanisms 8 min 30 Managing Complex EF Core Migrations (CI/CD) 8 min