Introduction to Entity Framework Core 6

Course Curriculum

Chapter 1: Introduction to Entity Framework Core

Lecture 1: Introduction

Lecture 2: What is Entity Framework Core?

Lecture 3: Versions

Lecture 4: Code First – Database First

Lecture 5: When to use EF Core?

Lecture 6: When NOT to use EF Core?

Lecture 7: EF Core vs Dapper

Lecture 8: Installing the EF Core CLI

Lecture 9: Configuring EF Core in a Console App

Lecture 10: Configuring EF Core in ASP.NET Core

Lecture 11: Summary

Lecture 12: Source code

Chapter 2: Modelling the Database

Lecture 1: Introduction

Lecture 2: Creating the Project

Lecture 3: Creating the Genre Entity

Lecture 4: Configuring the Primary Key in 3 Ways

Lecture 5: Defining the Max Length of a Property

Lecture 6: Non-Null Fields

Lecture 7: Changing Names and Schema

Lecture 8: Creating the Actor Entity

Lecture 9: Creating the Cinema Entity – Configuring Decimal

Lecture 10: NetTopologySuite – Modelling Spatial Data

Lecture 11: Creating the Movie Entity

Lecture 12: One-to-One Relationships

Lecture 13: One-to-Many Relationships

Lecture 14: Enums

Lecture 15: Default Value

Lecture 16: Many-to-Many Relationships: Skip Style

Lecture 17: Many-to-Many Relationships: Non-Skip Style

Lecture 18: Configure Conventions

Lecture 19: Configuration Classes

Lecture 20: Generating the Database Diagram

Lecture 21: Summary

Chapter 3: Querying Data

Lecture 1: Introduction

Lecture 2: Data Seeding

Lecture 3: Fetching a List of Records

Lecture 4: Not Keeping Track with AsNoTracking

Lecture 5: Fetching the First Record with First and FirstOrDefault

Lecture 6: Filtering with Where

Lecture 7: Pagination and IQueryable

Lecture 8: Selecting the Columns to Fetch

Lecture 9: AutoMapper and Projections

Lecture 10: Querying Spatial Data

Lecture 11: Ordering and Filtering Spatial Data

Lecture 12: Loading Related Data with Eager Loading

Lecture 13: Using ThenInclude

Lecture 14: Filtering and Ordering Related Data

Lecture 15: Related Data and AutoMapper

Lecture 16: Select Loading

Lecture 17: Explicit Loading

Lecture 18: Lazy Loading

Lecture 19: Deactivating Lazy Loading

Lecture 20: Grouping with GroupBy

Lecture 21: Deferred Execution

Lecture 22: Summary

Chapter 4: Creating, Updating and Deleting Data

Lecture 1: Introduction

Lecture 2: Connected Model and Disconnected Model

Lecture 3: Clean-Up

Lecture 4: Inserting Records

Lecture 5: Inserting Several Records

Lecture 6: Inserting Related Data

Lecture 7: Inserting Cinema with DTO

Lecture 8: Inserting a Movie

Lecture 9: Flexible Mapping

Lecture 10: Updating with the Connected Model

Lecture 11: Updating with the Disconnected Model

Lecture 12: Updating Records with Related Data

Lecture 13: Deleting Records

Lecture 14: Soft-Delete

Lecture 15: Query Filters

Lecture 16: Summary

Chapter 5: Configuring Properties

Lecture 1: Introduction

Lecture 2: Configuration Modes

Lecture 3: Primary Keys

Lecture 4: Ignoring Properties and Classes

Lecture 5: Configuring Indexes

Lecture 6: Index with Filters

Lecture 7: ValueConversions

Lecture 8: Custom ValueConversions

Lecture 9: Keyless Entities

Lecture 10: Working with Views

Lecture 11: Shadow Properties

Lecture 12: Automating Configurations with the Fluent API

Lecture 13: Summary

Chapter 6: Configuring Relationships

Lecture 1: Introduction

Lecture 2: Basic Terminology

Lecture 3: Clean up

Lecture 4: Configuration by Convention

Lecture 5: Required and Optional Relationships

Lecture 6: Foreign Key Attribute

Lecture 7: Inverse Property Attribute – Two Relationships to the Same Table

Lecture 8: Configuring One-to-One Relationships with the Fluent API

Lecture 9: Configuring One-to-Many Relationships with the Fluent API

Lecture 10: Configuring Many-to-Many Relationships – Without Skipping