Entity Framework Core Course Outline

Introduction

• What is an ORM?

• What is Entity Framework Core?

• History of Entity Framework

  • EF Core vs EF 6

• Introducing the Project

Installations

• Tools needed

Code-First

• Creating a Model

• Adding a Migration

• Reading or Writing Data

Existing Database (DB-First)

• Creating a Model for an Existing Database

• Scaffold-DbContext Command

• Using the DotNet CLI

DbContext

• Understanding the DbContext

• DbContext Methods and Properties

Querying Data

• Querying Basics

• Filtering Queries

• Sorting Data

• Aggregating Results

Tracking and Saving Data

• Tracking and Saving Workflow

• Insert, Update and Delete Simple Objects

• Updating Untracked Objects

• Tracking Multiple Objects and Bulk Support

Migrations

• Understanding Migrations

• Design-Time Migrations Tools

• Adding a Migration

• Inspecting a Migration

• Script or Create a Database

• Removing a Migration

• Reverting a Migration

• PMC and CLI Commands

Relationships

• Defining Many to Many Relationship

• Defining One to One Relationship

Defining One to Many Relationship

• EF Core’s Interpretation of Your Data Model

• Interpreting One-to-Many Relationships

• Foreign Key Properties

Interacting with Related Data

• Adding Related Data

• Eager Loading

• Lazy Loading

• Modifying Related Data

• Understanding Deleting

Working with Views and Stored Procedures

• Querying with Raw SQL

• Adding StoredProcedure using Migrations

• Running Stored Procedure Queries with Raw SQL

• Mapping to Views

• Querying Database Views

Data Annotations

Fluent API

Understanding EF Core's Database Connectivity

• EF Core Database Providers

• Transaction Support and Concurrency Handling

EF Core Pipeline