Entity Framework Core - The Complete Guide (.Net Core 7)

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

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 Tools Needed

Lecture 5 Project Resources

Lecture 6 Create Project

Lecture 7 N Tier

Lecture 8 Nuget Packages and Console Application

Section 2: Migrations

Lecture 9 Create ApplicationDbContext and Book Model

Lecture 10 Configuring Connection String

Lecture 11 Add Migration

Lecture 12 Understanding Migration

Lecture 13 Apply Migration

Lecture 14 Migration Snapshot

Lecture 15 Remove Migration and Update Existing Table

Lecture 16 Assignment 1 - Add Migration

Lecture 17 Remove Nullable

Lecture 18 Assignment 1 - Solution

Lecture 19 Nullable Updates to Table

Lecture 20 Renaming Column

Lecture 21 When to Add Migration?

Lecture 22 Rolling back to Old Migrations

Lecture 23 Reverting back and Deleting Migration

Lecture 24 More Commands

Lecture 25 Seed Data Using Migration

Section 3: Data Annotations

Lecture 26 Update Table and Column Name

Lecture 27 Key and Required Data Annotations

Lecture 28 MaxLength and NotMapped

Lecture 29 EF Core Power Tools

Lecture 30 Assignment 2 - Add Models and Tables

Lecture 31 Assignment 2 Solution - Add Models and Tables

Section 4: Relations in EF Core

Lecture 32 One to One

Lecture 33 Demo - One to One

Lecture 34 Correcting "One to One" Relation

Lecture 35 "One to Many" Relation

Lecture 36 Demo - "One to Many" and Apply Migrations

Lecture 37 Demo - One to Many

Lecture 38 Many to Many - Skip Mapping Table

Lecture 39 Many to Many - Manual Mapping Table

Lecture 40 Relation Mapping Summary

Section 5: Fluent API

Lecture 41 Setup Models for Fluent API

Lecture 42 Table and Column Name in Fluent API

Lecture 43 Required and Primary Key with Fluent API

Lecture 44 Not Mapped and Max Length with Fluent API

Lecture 45 Assignment 3 - Fluent API

Lecture 46 Assignment 3 Solution - Fluent API

Lecture 47 "One to One" Relation

Lecture 48 "One to Many" relation

Lecture 49 "Many to Many" - Skip Mapping Table

Lecture 50 "Many to Many" Manual Table

Lecture 51 How Smart EF Core is?

Lecture 52 Organize Fluent API

Section 6: Filtering Query

Lecture 53 Database Helper Methods

Lecture 54 Get All Books

Lecture 55 Creating Book

Lecture 56 Logging Query

Lecture 57 First and First or Default

Lecture 58 Filter Using Where

Lecture 59 FirstOrDefault

Lecture 60 Find

Lecture 61 Single and SingleOrDefault

Lecture 62 Contains, Like, and Aggregation

Lecture 63 Deferred Execution Overview

Lecture 64 Sorting Data

Lecture 65 Pagination Methods

Lecture 66 Update in EF Core

Lecture 67 Deleting Record in EF Core

Lecture 68 Async Methods

Section 7: EF Core CRUD

Lecture 69 Setup EF Core in Web Project

Lecture 70 Seed Category and Logging in EF Core

Lecture 71 Retrieve using EF Core

Lecture 72 Create and Update Get Action Method

Lecture 73 Create and Update Category EF Core

Lecture 74 Delete Category

Lecture 75 Assignment 4 - Code Should not Throw Exception

Lecture 76 Assignment 4 - Solution - No Exception Thrown

Lecture 77 Bulk Insert

Lecture 78 Bulk Remove

Lecture 79 Setup Author and Publisher Views

Lecture 80 Assignment 5 - Publisher and Author

Lecture 81 Assignment 5 - Solution - Publisher and Author CRUD

Section 8: Book Managment

Lecture 82 List all Books

Lecture 83 Projections in EF Core

Lecture 84 Book Upsert View

Lecture 85 Upsert and Delete in Action

Lecture 86 Explicit Loading in EF Core

Lecture 87 Load Book Details View

Lecture 88 Book Details in Action

Lecture 89 Correct Way of using Book Details

Lecture 90 Eager Loading

Lecture 91 Deferred Execution

Lecture 92 IQueryable vs IEnumerable - Maybe

Lecture 93 Attach vs Update

Section 9: Book and Author Assignment

Lecture 94 Book Author VM

Lecture 95 NOT IN LINQ Clause

Lecture 96 Assign Author to Book

Lecture 97 Remove Author from Book - "Many to Many' Relation

Lecture 98 Multi-Level Explicit Loading

Lecture 99 Eager Loading on Fire

Lecture 100 Lazy Loading Related Data

Lecture 101 Summarize Loading of Related Data

Section 10: Advance Concepts

Lecture 102 Change Tracker Demo

Lecture 103 Tracking Vs No Tracking

Lecture 104 Create View and Stored Proc

Lecture 105 Views in Action

Lecture 106 Raw SQL

Lecture 107 Executing Stored Proc

Section 11: OLD COURSE (.NET 5) Introduction

Lecture 108 Welcome

Lecture 109 ORM

Lecture 110 Entity framework core Introduction

Lecture 111 .NET 7 Update

Lecture 112 Tools needed

Lecture 113 GitHub and Project Snippets (Project Resources)

Lecture 114 Create Project

Lecture 115 N Tier

Lecture 116 Entity Framework Core Packages

Lecture 117 Add Connection String

Lecture 118 DbContext

Section 12: OLD COURSE (.NET 5) Migrations

Lecture 119 Create Category Model

Lecture 120 What are migrations.

Lecture 121 Add Migration

Lecture 122 Push Migration to Database

Lecture 123 Add Genre Model and Migration

Lecture 124 Modify Migration

Lecture 125 Migration Modification Scenarios Part 1

Lecture 126 Migration Modification Scenarios Part 2

Lecture 127 Reviews

Section 13: OLD COURSE (.NET 5) Data Annotations

Lecture 128 What are conventions

Lecture 129 Table Name and Column Name

Lecture 130 Required and Primary Key

Lecture 131 Max Length and Not Mapped

Lecture 132 Add more Models

Lecture 133 Database Generated Options

Lecture 134 Add Foreign Key

Lecture 135 Requirements Change and One to One Relationship

Lecture 136 One To Many Relationship

Lecture 137 Many to Many Relationship

Section 14: OLD COURSE (.NET 5) Fluent API

Lecture 138 Models for Fluent API

Lecture 139 Primary Key and Required

Lecture 140 Smartness of Entity Framework Core

Lecture 141 Not Mapped and Max Length

Lecture 142 Table Name and Column Name

Lecture 143 One to One Fluent API

Lecture 144 One to Many Fluent API

Lecture 145 Many to Many Fluent API

Lecture 146 Fluent API Code Roganization

Section 15: OLD COURSE (.NET 5) CRUD Operations in Entity Framework Core

Lecture 147 Insert Record with Migrations and Logging

Lecture 148 Reading using Entity Framework Core

Lecture 149 Create Update Fetch Records

Lecture 150 Insert and Edit in Entity Framework Core

Lecture 151 Delete in Entity Framework Core

Lecture 152 Bulk Operations in Entity Framework Core

Lecture 153 7 Bulk Remove in Entity Framework Core

Lecture 154 Assignment Setup Author and Publisher

Lecture 155 Assignment Solution Publisher and Author

Lecture 156 Book Index Action

Section 16: OLD COURSE (.NET 5) Section 6

Lecture 157 Projections in Entity Framework Core

Lecture 158 Book Upsert View

Lecture 159 Create and Update Book

Lecture 160 Explicit Loading

Lecture 161 Book Details Actions

Lecture 162 Book Details in Action

Lecture 163 Problem and Eager Loading

Lecture 164 Deffered Execution

Lecture 165 Demo - Deferred Execution

Lecture 166 IQueryable vs IEnumerable

Lecture 167 Attach vs Update

Lecture 168 Updating Entity Manually

Section 17: OLD COURSE (.NET 5) Entity Framework Core Advance Concepts

Lecture 169 Overview

Lecture 170 Book Author VM and Get Action

Lecture 171 NOT IN LINQ Clause

Lecture 172 Many to Many Demo

Lecture 173 Multi Level Explicit Loading

Lecture 174 Eager Loading on Fire

Section 18: OLD COURSE (.NET 5) SQL Views and More

Lecture 175 Change Tracker

Lecture 176 Change Tracker Demo

Lecture 177 Tracking vs no tracking

Lecture 178 Create View and Sproc

Lecture 179 Map View in DbContext

Lecture 180 Retrieve Data from Views

Lecture 181 Raw SQL

Lecture 182 Include Filters

Anyone who wants to learn EF Core