Mô tả

Overview

In this course, Entity Framework Core - A Full Tour, you will learn to work with data in your .NET applications.

When courses are created for .NET technologies, the details of Entity Framework and its sheer power are often neglected. We get distracted with abstractions and layers and need to focus on what Entity Framework is doing and can do.

In this course, we will review the general benefits of using Entity Framework Core, which is Microsoft’s flagship Object Relational Mapper (ORM), to relieve you of many concerns and challenges that come with this component of software development. We will also discover how EF Core translates classes and references to Database Models and Relationships.

We will learn how to write queries, update databases incrementally, roll back changes, and explore the myriad capabilities that Entity Framework Core affords us. This course is compatible with .NET 6 / .NET 7 / .NET 8.

When you finish this course, you’ll have the skills and knowledge of Entity Framework Core needed to easily interact with data and write queries for .NET Core applications.

By the end of watching this course, you'll be able to:

  • Construct a data model using code-first and database-first workflows.

  • Understand Entity Framework Commands for all operating systems.

  • Use migrations to manage database changes.

  • Apply Database validations and constraints.

  • Perform CRUD operations using LINQ.

  • Apply best practices with Entity Framework.

  • Extending Data Contexts

  • Understand how Change Tracking works.   

  • Manage Database Structure using Fluent API

  • Handle One-To-One, One-To-Many and Many-To-Many Relationships

  • Entity Framework Core 6 New Features

PREREQUISITES

To take this course, you should have at least three months of experience programming in C#. If you need to strengthen your C# fundamentals, you can take my C# beginner course C# Console and Windows Forms Development with LINQ & ADO .NET

You can also explore Database Development, which you can look at in the Complete Microsoft SQL Server Database Design Masterclass course.

Content and Overview

To take this course, you will need to know C#. Even if you have little exposure to the .NET development stack, this course is beginner-friendly and has development tips.

This premium course is smartly broken up to highlight related activities based on each module in the application being built. We will also look at troubleshooting and debugging errors as we go along, implementing best practices, writing efficient logic, and understanding why developers do things the way they do. Your knowledge will grow, step by step, throughout the course, and you will be challenged to be the best you can be.

The course is complete with working files hosted on GitHub, including some files to make it easier for you to replicate the demonstrated code. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Clicking the Take This Course button could be the best step to increase your income and marketability quickly! Also, remember that if you think the course is not worth your spending, you have a full 30 days to get a no-questions-asked refund!


It's time to take action!

See you in the course!

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

Entity Framework Core - In depth

Understand the differences between database-first and code-first workflows

Use migrations to manage changes to your database

Apply best practices with Entity Framework

Query data using LINQ (using query syntax and extension methods)

Use Fluent API To Manage Constraints and Design

Implement Database Relationships

Understand Change Tracking

Conduct RAW SQL Queries

Execute Stored procedures, Functions, View Queries

Yêu cầu

  • Some C# Knowledge
  • Some Database Development Knowledge

Nội dung khoá học

12 sections

Introduction

3 lectures
Introduction
01:34
IMPORTANT - .NET 8 Update
00:27
What is Entity Framework Core?
08:01

Environment Setup

4 lectures
Toolset Overview
02:56
Install Visual Studio - Windows
02:10
Install Visual Studio Code
01:45
Install .NET Core and EF Core Tools
03:25

Getting Started with Entity Framework Core

18 lectures
Section Overview
00:36
Setup Project Solution - Visual Studio
01:50
Setup Project Solution - Visual Studio Code + Dotnet CLI
06:41
What are Data Models?
01:50
Creating the Data Models with EF Core
08:37
Understanding the Database Context
04:18
Adding a Database Context
04:15
EF Core and Database Support
05:17
Specifying the Data Provider and Connection String
06:10
Understanding Code First Development and Migrations
04:19
Setup Console App Project
03:51
Adding a Migration
08:05
Generating a Database (Code-First)
03:59
Understanding Database First Development
02:10
Reverse Engineer Existing Database
08:15
Seeding Data
08:22
Section Review
02:34
Section Source Code
00:00

Using Entity Framework Core to Query a Database

20 lectures
Section Overview
00:43
Adding Verbose Logging to EF Core’s Workload
02:31
Fix: Database Connection String Refactor
04:30
LINQ as Entity Framework Core Syntax
02:10
Querying Basics
07:15
Synchronous vs. Asynchronous Syntax
02:39
Querying for a Single Record
15:08
Add Filters to Queries
10:03
Additional Filtering Features
08:50
Alternative LINQ Syntax
05:14
Aggregate Methods
06:11
Group By
11:14
Order By
06:33
Skip and Take
11:32
Projections and Custom Data Types
08:46
Tracking Vs. No Tracking (Enhancing Performance)
04:30
IQueryables vs List Types
10:40
Efficient Querying Tips and Tricks
03:52
Section Review
02:32
Section Source Code
00:00

Using Entity Framework Core to Manipulate Data

8 lectures
Section Overview
00:46
Understanding Tracking and Saving Changes
05:18
Simple Insert Operations
13:28
Simple Update Operations
09:36
Simple Delete Operations
02:28
ExecuteUpdate and ExecuteDelete (>= EF Core 7)
06:39
Section Review
01:20
Section Source Code
00:00

Handling Database Changes and Migrations

11 lectures
Section Overview
00:39
Review Entity Framework Core Migrations
03:43
Adding More Entities
06:01
Updating Database with Migration(s)
12:50
Using Configuration Files
07:11
Generating Migration Scripts
07:22
Rolling Back Migrations and Database Changes
06:58
EF Bundles
04:04
Applying Migrations at Runtime
04:04
Section Review
02:22
Section Source Code
00:00

Interacting With Related Records

20 lectures
Section Overview
01:00
Database Relationships and Entity Framework Core
02:34
One to Many Relationships
02:44
Adding One-To-Many Relationships
07:12
View Diagram with Entity Framework Core Tools
03:39
Many to Many Relationships
04:48
Adding Many-To-Many Relationships
11:09
Understanding One-To-One Relationships
04:08
Adding One-To-One Relationships
03:59
Update Database With Relationships
13:10
Inserting Related Data
13:44
Understanding Loading Methods
02:34
Including Related Data with Eager Loading
09:33
Including Related Data with Explicit Loading
06:51
Including Related Data with Lazy Loading
08:11
Filtering on Related Records
07:02
Projections and Anonymous Data Types
09:23
Understanding Delete Behaviors
07:17
Section Review
03:50
Section Source Code
00:00

Working With Raw SQL, Views and Stored Procedures

10 lectures
Section Overview
00:32
Adding Non-Table Objects with Migrations
04:15
Querying Keyless Entities (Like Views)
07:25
Querying with Raw SQL - Part 1
08:12
Querying with Raw SQL - Part 2
09:23
Querying scalar
02:19
Executing User-defined Funcitons
05:47
Limitations of Raw Queries and EF Core
01:24
Section Review
01:44
Section Source Code
00:00

ASP.NET Core and EF Core

11 lectures
Section Overview
00:37
How EF Core and ASP.NET Core Work
04:50
Create ASP.NET Core Project
06:51
Connect to the Database Context
15:27
Fixing EF Core Design Time Errors
10:17
Scaffolding Code with Visual Studio
05:00
Scaffolding Code with Visual Studio Code
02:50
Exploring Scaffolded Code
07:12
Review Best Practices
09:06
Section Review
02:54
Section Source Code
00:00

Additional Features and Considerations

10 lectures
Section Overview
01:04
Manipulate Entries Before Saving Changes
13:42
SQL Server Temporal Tables
15:04
Data Validation with Data Annotations
07:48
Pre-convention model configuration
02:22
Support For Database Transactions
08:58
Handling Data Concurrency Issues
12:56
Using Query Filters
08:45
Database Connection Retry and Timeout Policies
06:25
Section Source Code
00:00

Conclusion

1 lectures
Conclusion
04:26

Bonus Section

1 lectures
Bonus Lecture
00:05

Đá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.