Entity Framework Core – A Full Tour

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: IMPORTANT – .NET 8 Update

Lecture 3: What is Entity Framework Core?

Chapter 2: Environment Setup

Lecture 1: Toolset Overview

Lecture 2: Install Visual Studio – Windows

Lecture 3: Install Visual Studio Code

Lecture 4: Install .NET Core and EF Core Tools

Chapter 3: Getting Started with Entity Framework Core

Lecture 1: Section Overview

Lecture 2: Setup Project Solution – Visual Studio

Lecture 3: Setup Project Solution – Visual Studio Code + Dotnet CLI

Lecture 4: What are Data Models?

Lecture 5: Creating the Data Models with EF Core

Lecture 6: Understanding the Database Context

Lecture 7: Adding a Database Context

Lecture 8: EF Core and Database Support

Lecture 9: Specifying the Data Provider and Connection String

Lecture 10: Understanding Code First Development and Migrations

Lecture 11: Setup Console App Project

Lecture 12: Adding a Migration

Lecture 13: Generating a Database (Code-First)

Lecture 14: Understanding Database First Development

Lecture 15: Reverse Engineer Existing Database

Lecture 16: Seeding Data

Lecture 17: Section Review

Lecture 18: Section Source Code

Chapter 4: Using Entity Framework Core to Query a Database

Lecture 1: Section Overview

Lecture 2: Adding Verbose Logging to EF Core’s Workload

Lecture 3: Fix: Database Connection String Refactor

Lecture 4: LINQ as Entity Framework Core Syntax

Lecture 5: Querying Basics

Lecture 6: Synchronous vs. Asynchronous Syntax

Lecture 7: Querying for a Single Record

Lecture 8: Add Filters to Queries

Lecture 9: Additional Filtering Features

Lecture 10: Alternative LINQ Syntax

Lecture 11: Aggregate Methods

Lecture 12: Group By

Lecture 13: Order By

Lecture 14: Skip and Take

Lecture 15: Projections and Custom Data Types

Lecture 16: Tracking Vs. No Tracking (Enhancing Performance)

Lecture 17: IQueryables vs List Types

Lecture 18: Efficient Querying Tips and Tricks

Lecture 19: Section Review

Lecture 20: Section Source Code

Chapter 5: Using Entity Framework Core to Manipulate Data

Lecture 1: Section Overview

Lecture 2: Understanding Tracking and Saving Changes

Lecture 3: Simple Insert Operations

Lecture 4: Simple Update Operations

Lecture 5: Simple Delete Operations

Lecture 6: ExecuteUpdate and ExecuteDelete (>= EF Core 7)

Lecture 7: Section Review

Lecture 8: Section Source Code

Chapter 6: Handling Database Changes and Migrations

Lecture 1: Section Overview

Lecture 2: Review Entity Framework Core Migrations

Lecture 3: Adding More Entities

Lecture 4: Updating Database with Migration(s)

Lecture 5: Using Configuration Files

Lecture 6: Generating Migration Scripts

Lecture 7: Rolling Back Migrations and Database Changes

Lecture 8: EF Bundles

Lecture 9: Applying Migrations at Runtime

Lecture 10: Section Review

Lecture 11: Section Source Code

Chapter 7: Interacting With Related Records

Lecture 1: Section Overview

Lecture 2: Database Relationships and Entity Framework Core

Lecture 3: One to Many Relationships

Lecture 4: Adding One-To-Many Relationships

Lecture 5: View Diagram with Entity Framework Core Tools

Lecture 6: Many to Many Relationships

Lecture 7: Adding Many-To-Many Relationships

Lecture 8: Understanding One-To-One Relationships

Lecture 9: Adding One-To-One Relationships

Lecture 10: Update Database With Relationships

Lecture 11: Inserting Related Data

Lecture 12: Understanding Loading Methods

Lecture 13: Including Related Data with Eager Loading

Lecture 14: Including Related Data with Explicit Loading

Lecture 15: Including Related Data with Lazy Loading

Lecture 16: Filtering on Related Records

Lecture 17: Projections and Anonymous Data Types

Lecture 18: Understanding Delete Behaviors

Lecture 19: Section Review

Lecture 20: Section Source Code

Chapter 8: Working With Raw SQL, Views and Stored Procedures

Lecture 1: Section Overview

Lecture 2: Adding Non-Table Objects with Migrations

Lecture 3: Querying Keyless Entities (Like Views)

Lecture 4: Querying with Raw SQL – Part 1

Lecture 5: Querying with Raw SQL – Part 2

Lecture 6: Querying scalar

Lecture 7: Executing User-defined Funcitons

Lecture 8: Limitations of Raw Queries and EF Core