Entity Framework core: SQL Data Access with C# & .Net

Course Curriculum

Chapter 1: What is Entity Framework Core and what do we need it for?

Lecture 1: What is EF? What is an ORM?

Lecture 2: Benefits & Drawbacks of EF core explained

Lecture 3: First Impression of EF core with SQlite and Database first approach

Lecture 4: Learn the basic concpets of EF core

Lecture 5: Working with the course materials

Lecture 6: Update Uploaded Code for the chapters.

Lecture 7: Summary of the first chapter

Chapter 2: Database first & Code first approach

Lecture 1: Introduction to the example Application and its entites for the course.

Lecture 2: Add the EF Core Providers as Nuget Packages for SQlite, MariaDb and PostgreSQL

Lecture 3: Create a Database with SQlite

Lecture 4: Database inside a Docker Container: PostgreSQL

Lecture 5: Extract the DbContext and Entities from the existing Databases

Lecture 6: Code First I: Create POCOs (Model Entities)

Lecture 7: Code First II: Create the DatabaseContext

Lecture 8: Code First III: Use the InitialMigration and update the Database

Lecture 9: Code First IV: Conventions and Attributes

Lecture 10: Summary Code first and Db First

Chapter 3: Utilize the Entity Framework Query API

Lecture 1: Introduction to DbContext and Querying

Lecture 2: Create UseCases for the Application

Lecture 3: Seed Data: Add AddRange and SaveChanges

Lecture 4: Query Interface with DbContext I: ToList, First, Single, Last and Any

Lecture 5: Query Interface with DbContext II: Include & ThenInclude

Lecture 6: Improve read speed with AsNoTracking

Lecture 7: Evaluation of Queries

Lecture 8: Any Query and Insert into Linking Tables

Lecture 9: Update and Delete with Entity Framework Core

Lecture 10: Summary of the Query Api so far

Chapter 4: Alter the Database with Entity Framework Core Migrations

Lecture 1: Introduction to Migrations

Lecture 2: Add a Property with Migrations

Lecture 3: Change a Migration manually

Lecture 4: Revert a failed Migration

Lecture 5: 3 Ways to apply Migrations to the Database

Lecture 6: Apply Migrations from Code and as SQL Script

Lecture 7: Alter Entity Relationships with Migrations

Lecture 8: Learn what Shadow Properties are and what they are used for.

Lecture 9: How to use Shadow Properties

Lecture 10: Summary Migrations

Chapter 5: Reporting on the Example Application (Lean Production Trainer)

Lecture 1: What do we want to find out about our data?

Lecture 2: Report 1: Product related time to produce

Lecture 3: Report 2: Which Station needs the most time to complete the work step?

Lecture 4: Report 3: Which step is the overall most costly one?

Chapter 6: Advanced Topics with Entity Framework Core

Lecture 1: Intro to the advanced Topics of Entity Framework core section

Lecture 2: Understand the ChangeTracking Feature

Lecture 3: Look deeper into ChangeTracking and control it manually

Lecture 4: Utilize ChangeTracking Events to handle it manually

Lecture 5: Understand how Raw SQL and Querytypes work and what we need them for

Lecture 6: RawSql: Execute SQL Statements directly with Entity Framework Core

Lecture 7: Query Types: Query MariaDB Views without Table or Table Entities

Lecture 8: Mapping explained with Logging for EF core

Lecture 9: Sql Inheritance explained with postgreSql database

Lecture 10: Inheritance with Entity Framework Core

Lecture 11: Summary of advanced Ef Core Concepts

Chapter 7: Bonus: Things you might want to know for this course

Lecture 1: LINQ Basics: Extension Methods

Lecture 2: LINQ Basics: Anonymous Types

Lecture 3: SQL Basics: Tables and Data Types

Lecture 4: SQL Basics: Relationships

Lecture 5: More Resources