✅ Entity Framework Core & LINQ — Course Index

🗄️ Section 1 — Database & ORM Fundamentals

Build strong foundations before touching Entity Framework Core.

• Lesson 1 — What is a Database?
  Understanding data, databases, and real-world usage.
• Lesson 2 — Tables, Rows, Primary & Foreign Keys
  Relational database concepts explained simply.
• Lesson 3 — SQL vs ORM (Why EF Core?)
  Problems with raw SQL and benefits of ORM.

⚙️ Section 2 — Entity Framework Core Setup & Basics

• Lesson 4 — Introduction to Entity Framework Core
  What EF Core is and how it works internally.
• Lesson 5 — Setting Up EF Core in ASP.NET Core
  Installing packages and configuring DbContext.
• Lesson 6 — Entities & DbContext Explained
  POCO classes, DbSet, and best practices.

🧱 Section 3 — EF Core Migrations

• Lesson 7 — What are Migrations?
  Why migrations are important in real projects.
• Lesson 8 — Add & Apply Migrations
  Add-Migration and Update-Database in depth.
• Lesson 9 — Migration Errors & Fixes
  Common issues and safe recovery techniques.

🔍 Section 4 — LINQ Fundamentals

• Lesson 10 — Introduction to LINQ
  LINQ basics, lambda expressions, and syntax.
• Lesson 11 — Where & Select in LINQ
  Filtering and projecting data.
• Lesson 12 — Sorting & Aggregation
  OrderBy, Count, Any, Sum, and more.

✏️ Section 5 — CRUD Operations with EF Core

• Lesson 13 — Insert Data
  Add, AddRange, and SaveChanges.
• Lesson 14 — Read & Update Data
  Tracking, updates, and partial updates.
• Lesson 15 — Delete & Soft Delete
  Hard delete vs soft delete strategies.

⚡ Section 6 — Async EF Core & Performance

• Lesson 16 — Async Programming in EF Core
  ToListAsync, SaveChangesAsync, and benefits.
• Lesson 17 — Performance Optimization
  AsNoTracking, IQueryable vs IEnumerable.

🔗 Section 7 — Relationships in EF Core

• Lesson 18 — One-to-Many Relationship
  Navigation properties and foreign keys.
• Lesson 19 — Many-to-Many Relationship
  Junction tables and EF Core conventions.
• Lesson 20 — Loading Related Data
  Eager, lazy, and explicit loading.

🧠 Section 8 — Advanced LINQ

• Lesson 21 — GroupBy & Joins
  Reporting and real-world queries.
• Lesson 22 — Writing Complex LINQ Queries
  Dynamic and conditional queries.

🌍 Section 9 — Real-World API Features

• Lesson 23 — Pagination & Sorting
  Skip, Take, and API best practices.
• Lesson 24 — DTOs & Projections
  Optimizing data transfer.

🔐 Section 10 — Advanced EF Core Concepts

• Lesson 25 — Transactions & Concurrency
  Handling data consistency safely.
• Lesson 26 — Raw SQL & Stored Procedures
  When and how to use raw SQL.

🏗️ Section 11 — Architecture & Best Practices

• Lesson 27 — Repository & Unit of Work
  Clean architecture with EF Core.
• Lesson 28 — Testing EF Core Applications
  InMemory DB and unit testing.

🎯 Section 12 — Projects & Interview Preparation

• Project — Student Management System
  Complete CRUD with relationships.
• Lesson 29 — EF Core & LINQ Interview Questions
  Real interview scenarios and answers.