Mô tả

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 Core

  • Use 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 objects

  • Apply best practices with Entity Framework

  • Understand relationships in Entity Framework Core

  • Bulk operations in Entity Framework Core

  • Change tracker, RAW SQL, Stored Procs, View, and much more.

Bạn sẽ học được gì

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.

Yêu cầu

  • Basic knowledge of .NET Core
  • Basic knowledge of c# / SQL

Nội dung khoá học

10 sections

Introduction

8 lectures
Welcome
01:55
ORM
05:19
Entity Framework Core Introduction
02:34
Tools Needed
00:51
Project Resources
00:54
Create Project
02:31
N Tier
04:49
Nuget Packages and Console Application
06:41

Migrations

17 lectures
Create ApplicationDbContext and Book Model
04:26
Configuring Connection String
03:13
Add Migration
03:37
Understanding Migration
02:50
Apply Migration
01:56
Migration Snapshot
01:54
Remove Migration and Update Existing Table
05:40
Assignment 1 - Add Migration
01:02
Remove Nullable
01:40
Assignment 1 - Solution
02:10
Nullable Updates to Table
02:00
Renaming Column
02:16
When to Add Migration?
04:06
Rolling back to Old Migrations
02:21
Reverting back and Deleting Migration
04:08
More Commands
01:49
Seed Data Using Migration
02:32

Data Annotations

6 lectures
Update Table and Column Name
02:32
Key and Required Data Annotations
03:44
MaxLength and NotMapped
02:24
EF Core Power Tools
01:58
Assignment 2 - Add Models and Tables
02:16
Assignment 2 Solution - Add Models and Tables
03:18

Relations in EF Core

9 lectures
One to One
01:36
Demo - One to One
05:26
Correcting "One to One" Relation
01:36
"One to Many" Relation
01:01
Demo - "One to Many" and Apply Migrations
02:54
Demo - One to Many
05:23
Many to Many - Skip Mapping Table
03:35
Many to Many - Manual Mapping Table
06:32
Relation Mapping Summary
01:53

Fluent API

12 lectures
Setup Models for Fluent API
04:27
Table and Column Name in Fluent API
04:29
Required and Primary Key with Fluent API
02:17
Not Mapped and Max Length with Fluent API
02:53
Assignment 3 - Fluent API
00:40
Assignment 3 Solution - Fluent API
02:42
"One to One" Relation
04:14
"One to Many" relation
03:30
"Many to Many" - Skip Mapping Table
02:16
"Many to Many" Manual Table
04:11
How Smart EF Core is?
02:32
Organize Fluent API
07:54

Filtering Query

16 lectures
Database Helper Methods
03:07
Get All Books
03:23
Creating Book
03:48
Logging Query
03:11
First and First or Default
03:49
Filter Using Where
03:56
FirstOrDefault
03:07
Find
01:34
Single and SingleOrDefault
03:34
Contains, Like, and Aggregation
03:08
Deferred Execution Overview
02:26
Sorting Data
03:53
Pagination Methods
02:03
Update in EF Core
04:43
Deleting Record in EF Core
01:19
Async Methods
02:17

EF Core CRUD

13 lectures
Setup EF Core in Web Project
06:16
Seed Category and Logging in EF Core
04:35
Retrieve using EF Core
04:30
Create and Update Get Action Method
03:24
Create and Update Category EF Core
05:14
Delete Category
02:16
Assignment 4 - Code Should not Throw Exception
00:32
Assignment 4 - Solution - No Exception Thrown
00:55
Bulk Insert
06:43
Bulk Remove
03:13
Setup Author and Publisher Views
05:17
Assignment 5 - Publisher and Author
01:22
Assignment 5 - Solution - Publisher and Author CRUD
03:28

Book Managment

11 lectures
List all Books
02:17
Projections in EF Core
06:47
Book Upsert View
01:12
Upsert and Delete in Action
03:19
Explicit Loading in EF Core
06:01
Load Book Details View
02:28
Book Details in Action
04:04
Correct Way of using Book Details
04:06
Eager Loading
04:54
Deferred Execution
04:05
IQueryable vs IEnumerable
03:47

Book and Author Assignment

8 lectures
Book Author VM
05:04
NOT IN LINQ Clause
04:16
Assign Author to Book
03:26
Remove Author from Book - "Many to Many' Relation
03:06
Multi-Level Explicit Loading
04:44
Eager Loading on Fire
02:42
Lazy Loading Related Data
05:14
Summarize Loading of Related Data
01:06

Advance Concepts

7 lectures
Change Tracker Demo
05:45
Tracking Vs No Tracking
03:22
Create View and Stored Proc
06:10
Views in Action
01:49
Raw SQL
03:56
Executing Stored Proc
02:50
Bonus - Change Schema and Table Name for .NET Identity (Youtube Video)
11:19

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.