Entity FrameWork Core - The Complete Guide (.Net Core 7)
Entity Framework Core - The Complete Guide (.Net Core 7)
Last updated 4/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 7.45 GB | Duration: 11h 26m
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
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