Entity Framework Core - The Complete Guide (.Net Core 5) (updated 8/2022)

Learn Entity Framework Core using Code First Methodology in ASP.NET Core 5 (.NET 5)

What you'll learn
Entity Framework Core
Migrations in Entity Framework
Fluent API
Data Annotations
Best practices with Entity Framework Core
Relationships in Entity Framework Core
Bulk operations in Entity Framework Core
Change tracker, RAW SQL, Stored Procs, View, and much more.
Requirements
Basic knowledge of .NET Core
Basic knowledge of c# / SQL
Description
Entity Framework is a term that goes hand by hand with ASP.NET Core. It is one of that technology that is used very often and is not understood most of the time.This course will teach you everything you need to know about using Entity Framework Core with ASP.NET Core. The skills you will learn will help you to build and architect complex ASP.NET Core applications that make full use of Entity Framework Core with Code First. We will start with the basic fundamentals of Entity Framework Core and then we would dive into advanced concepts.Unlike other courses, which are outdated or do not convert all the topics. I have especially taken care to keep the course updated as well as cover topics from beginner to advanced topics with Entity Framework Core.By the end of watching this course, you'll be able to:Understand the basics of Entity Framework CoreUse code-first migrations to push changes to the database, and learn how to manage them.Override code-first conventions (using data annotations and fluent API)Understand how LINQ works and how to filter data.Add, update and remove objectsApply best practices with Entity FrameworkUnderstand relationships in Entity Framework CoreBulk operations in Entity Framework CoreChange tracker, RAW SQL, Stored Procs, View, and much more.

Overview

Section 1: Introduction

Lecture 1 Welcome

Lecture 2 ORM

Lecture 3 Entity framework core Introduction

Lecture 4 .NET 7 Update

Lecture 5 Tools needed

Lecture 6 GitHub and Project Snippets (Project Resources)

Lecture 7 Create Project

Lecture 8 N Tier

Lecture 9 Entity Framework Core Packages

Lecture 10 Add Connection String

Lecture 11 DbContext

Section 2: Migrations

Lecture 12 Create Category Model

Lecture 13 What are migrations.

Lecture 14 Add Migration

Lecture 15 Push Migration to Database

Lecture 16 Add Genre Model and Migration

Lecture 17 Modify Migration

Lecture 18 Migration Modification Scenarios Part 1

Lecture 19 Migration Modification Scenarios Part 2

Lecture 20 Reviews

Section 3: Data Annotations

Lecture 21 What are conventions

Lecture 22 Table Name and Column Name

Lecture 23 Required and Primary Key

Lecture 24 Max Length and Not Mapped

Lecture 25 Add more Models

Lecture 26 Database Generated Options

Lecture 27 Add Foreign Key

Lecture 28 Requirements Change and One to One Relationship

Lecture 29 One To Many Relationship

Lecture 30 Many to Many Relationship

Section 4: Fluent API

Lecture 31 Models for Fluent API

Lecture 32 Primary Key and Required

Lecture 33 Smartness of Entity Framework Core

Lecture 34 Not Mapped and Max Length

Lecture 35 Table Name and Column Name

Lecture 36 One to One Fluent API

Lecture 37 One to Many Fluent API

Lecture 38 Many to Many Fluent API

Lecture 39 Fluent API Code Roganization

Section 5: CRUD Operations in Entity Framework Core

Lecture 40 Insert Record with Migrations and Logging

Lecture 41 Reading using Entity Framework Core

Lecture 42 Create Update Fetch Records

Lecture 43 Insert and Edit in Entity Framework Core

Lecture 44 Delete in Entity Framework Core

Lecture 45 Bulk Operations in Entity Framework Core

Lecture 46 7 Bulk Remove in Entity Framework Core

Lecture 47 Assignment Setup Author and Publisher

Lecture 48 Assignment Solution Publisher and Author

Lecture 49 Book Index Action

Section 6: Section 6

Lecture 50 Projections in Entity Framework Core

Lecture 51 Book Upsert View

Lecture 52 Create and Update Book

Lecture 53 Explicit Loading

Lecture 54 Book Details Actions

Lecture 55 Book Details in Action

Lecture 56 Problem and Eager Loading

Lecture 57 Deffered Execution

Lecture 58 Demo - Deferred Execution

Lecture 59 IQueryable vs IEnumerable

Lecture 60 Attach vs Update

Lecture 61 Updating Entity Manually

Section 7: Entity Framework Core Advance Concepts

Lecture 62 Overview

Lecture 63 Book Author VM and Get Action

Lecture 64 NOT IN LINQ Clause

Lecture 65 Many to Many Demo

Lecture 66 Multi Level Explicit Loading

Lecture 67 Eager Loading on Fire

Section 8: SQL Views and More

Lecture 68 Change Tracker

Lecture 69 Change Tracker Demo

Lecture 70 Tracking vs no tracking

Lecture 71 Create View and Sproc

Lecture 72 Map View in DbContext

Lecture 73 Retrieve Data from Views

Lecture 74 Raw SQL

Lecture 75 Include Filters

Anyone who wants to learn EF Core