Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Entity Framework Core Fundamentals (EF Core)
Important Introduction
About This Course (12:08)
Telegram Group for This Course
🟦 Module 1 - From ADO.NET to EF Core -🔥 (Critical Foundation — Do Not Skip)
📌 Module Intent (7:19)
📋 How to Study This Module
📖 The Problem with Traditional Data Access (19:14)
❓ Quiz — The Problem with Traditional Data Access
📖 What is ORM? (From Tables to Objects) (24:18)
❓ Quiz — What is ORM? (From Tables to Objects)
📖 Introduction to Entity Framework Core (19:05)
❓ Quiz — Introduction to Entity Framework Core
📖 EF Core as a Translator (LINQ → SQL) (🔥Important don't skipp!) (11:45)
❓ Quiz — EF Core as a Translator (LINQ → SQL)
📖 EF Core as a Query Builder, Not Executor (12:42)
❓ Quiz — EF Core as a Query Builder, Not Executor
📖 How EF Core Works Internally (🔥 One of the most important lessons ) (17:31)
❓ Quiz — How EF Core Works Internally
📖 EF Core as a State Machine (Change Tracker) (15:41)
❓ Quiz — EF Core as a State Machine (Change Tracker)
📖 EF Core Does NOT Execute Your Code (SQL Does) (8:17)
❓ Quiz — EF Core Does NOT Execute Your Code (SQL Does)
📖 EF Core is NOT the Database (Biggest Misconception) (12:46)
❓ Quiz — EF Core is NOT the Database (Biggest Misconception)
📖 EF vs ADO.NET (When to Use Each) (34:32)
❓ Quiz — EF Core vs ADO.NET (When to Use Each)
📖 EF in Architecture (13:45)
❓ Quiz — EF Core in Architecture
📖 EF Core Performance Depends on How You Use It
📖 Entity Framework Core History
📖 What Does LTS Mean? (.NET 8 — LTS)
📖 Why We Use EF Core 8 in This Course (Not the Latest Version)
🧠 📌 Module Summary
🟦 Module 2 — Environment Setup
📌 Module Intent
📖 Installing Visual Studio (Latest Version 2026) (7:00)
📖 Choosing the Database for This Course
📖 Installing SQL Server Express & SSMS Step by Step (10:13)
📖 Installing Entity Framework Core
🧠 📌 Module Summary
🟦 Module 3 - Code First or Database First
📌 Module Intent
📖 Code First vs Database First (23:46)
📖 When to Use Each Approach (Self Read)
📖 Why We Will Start with Database First (15:30)
📖 How EF Core Reads an Existing Database (Scaffolding 🔥) (13:17)
📖 How to Run Scaffolding in EF Core (Step-by-Step 🔥) (12:55)
🧠 📌 Module Summary
🟦 Module 4 — Database First (Starting Point 🔥)
📌 Module Intent
📖 Creating and Seeding the TrainingCenterDB Database in SSMS 22 (Step-by-Step 🔥) (17:04)
📖 Understanding the TrainingCenterDB Design (Schema, Relationships, Constrains...etc) (51:55)
🧠 📌 Module Summary
🟦 Module 5 — Connecting EF to Existing Database
📌 Module Intent
📖 Tables vs Entities & Creating Entity Classes (TrainingCenterDB) (17:56)
📖 Creating DbContext (18:04)
📖 Registering DbContext and Connecting EF Core to SQL Server (10:16)
📖 Retrieve & Print Data (7:17)
🧠 📌 Module Summary
🟦 Module 6 — Tracing and Logging Queries
📌 Module Intent
📖 Tracing and Logging Queries in EF Core 🔥 (10:52)
🧠 📌 Module Summary
🟦 Module 7 — Querying Data with LINQ
📌 Module Intent
📖 LINQ Review for EF (Self Read)
📖 Deferred Execution (Self Read)
📖 Filtering Data (6:39)
📖 Retrieving Single Records (First, FirstOrDefault, Single, SingleOrDefault ) (14:25)
📖 Find() vs FirstOrDefault() (Primary Key Retrieval 🔥) (5:10)
📖 Projection (Select) (3:19)
📖 Sorting + combining queries (Where + Select + OrderBy) (6:38)
📖 Checking Existence with Any() + All() 🔥 (17:49)
📖 Aggregations in EF Core (Count, Sum, Average 🔥) - Good and Bad Ways ! (8:26)
📖 Min() + Max() (Finding Lowest and Highest Values 🔥) (Self Read)
📖 Distinct + GroupBy (Reports & Real Queries 🔥) (6:09)
📖 HAVING with GroupBy in EF Core (Filtering Groups After Aggregation 🔥) (3:22)
📖 Loading Related Data (Include) + N+1 Problem 🔥 (10:06)
📖 Include vs Projection (N+1 → Include → Best Practice 🔥) (10:37)
📖 Include() vs ThenInclude() in EF Core (6:16)
📖 Join Types in Databases (Quick Essential Guide 🔥) (5:03)
📖 Join Queries in EF Core (Combining Tables Without Include 🔥) (4:07)
📖 Left Join in EF Core (Optional Related Data 🔥) (6:05)
📖 SelectMany() in EF Core (Flattening Related Collections 🔥) (4:10)
📖 Subqueries in EF Core (Queries Inside Queries 🔥) (5:39)
📖 Pagination (Skip & Take — Handling Large Data 🔥) (11:52)
🧠 📌 Module Summary
🟦 Module 8 — Change Tracking (Critical)
📌 Module Intent
📖 What is Change Tracking (20:30)
📖 Entity States in EF Core (Detached, Unchanged, Modified, Added, Deleted) 🔥 (11:58)
📖 How EF Core Detects Property Changes Internally 🔥 (11:19)
📖 AutoDetectChangesEnabled vs Manual Detection 🔥 (13:39)
📖 Tracking vs NoTracking: AsNoTracking() (Read-Only Queries & Performance 🔥) (8:43)
🧠 📌 Module Summary
🟦 Module 9 — CRUD Operations (On Existing DB)
📌 Module Intent
📖 Reading Existing Data Before Changes - Retrieve Data
📖 Updating Data in EF Core (Change Tracker in Action 🔥) (6:59)
📖 Updating Detached Entities in Real APIs 🔥 (22:34)
📖 Insert & Delete in EF Core (9:18)
📖 Insert vs Update vs Attach vs Entry State Control 🔥 (Self Read)
📖 SaveChanges() Pipeline — What Happens Internally 🔥 (Self Read)
📖 Async Operations in EF Core (Queries + SaveChangesAsync) 🔥 (15:51)
📖 Why SaveChanges in Loops Is Dangerous 🔥 (Self Read)
📖 Bulk Operations & Performance Optimization (🔥 Advanced but Practical) (13:02)
📖 Batch Updates vs Real EF Tracking Updates 🔥 (Self Read)
📖 Change Tracker Memory Problems & Long-Lived DbContext 🔥 (4:03)
📖 Common Change Tracking Mistakes in Real Projects 🔥 (Self Read)
🧠 📌 Module Summary
🟦Module 10 - Transactions in EF Core
📌 Module Intent
📖 Transactions in EF Core (All or Nothing Updates 🔥) (6:45)
🧠 📌 Module Summary
🟦 Module 11 — Relationship Loading Strategies in EF Core 🔥
📌 Module Intent
📖 Lazy Loading vs Eager Loading in EF Core 🔥 (13:33)
📖 How to Configure Lazy Loading in EF Core (Full Working Example 🔥) (9:26)
📖 Explicit Loading vs Lazy Loading vs Eager Loading in EF Core 🔥 (8:09)
🧠 📌 Module Summary
End Course Message
End of Course Message
📖 Reading Existing Data Before Changes - Retrieve Data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock