Complete guide to Entity Framework Core

Name: Complete guide to Entity Framework Core
Rating: 4.5 (70 reviews)

Work with a database from your .NET Core application

Highest Rated

Created byScott Noel

Last updated 12/2020

English

What you'll learn

This course will introduce you to EF Core particularly in building web and API applications. This course focuses on the code first approach and will show you how to manage a database with EF, create data models, and perform complex tasks with EF.

Course content

9 sections • 50 lectures • 4h 20m total length

Introduction2:19
About Me - Scott Noel1:58
How to use this course1:07

Why Entity Framework5:02
Understand why you would use Entity Framework in your application
Entity Framework Prerequisites1:32
What you need to have set up before you start working with Entity Framework
Create your first Entity Framework project6:38
Create a web application using Entity Framework
Create a database context5:11
Create your first database context
Setup your database configuration6:10
Summary2:05

Database Migrations Introduction1:31
Your first database migration5:38
Using a migration to modify your existing database tables3:25
Modifying a model with data annotations5:14
Create custom error messages with data annotations2:36
Removing data migrations2:32
Adding a second database table and overriding Entity Framework defaults10:30
Field range validation with data annotations2:00
Not Mapped Property4:24
Sometimes you do not want to write a property to the database as a database field. Use the NotMapped database annotation for that.
Data migrations summary0:51

Multiple Model Introduction2:17
Adding Navigation properties7:24
Navigation properties are what we use to link two classes together. These navigation properties will also help link our databases together using a concept of foreign keys.
Entity Relationship definition3:43
Removing a navigation property9:16
In this lesson we will learn how to remove a navigation property we have already applied to our database.
Multiple navigation properties15:10

What is a repository Layer8:31
Creating a generic repository Interface6:38
Creating the generic repository Implementation details7:13
Build application specific repository interfaces2:46
Create application specific repository implementations4:26
Extend the generic repository to build a user repository and implement its contract. Wire it to the application DB context and add a get by first name method.
Implementing a Unit of Work6:17
Using the the unit of work and repositories in your code5:16

Requirements

Familiarity with the C# language and basic relational database skills. Ideally working knowledge of an IDE such as Visual Studio

Description

This course is a complete guide to Entity Framework Core. Whether your are a beginner or more advanced this course is for you. In this course you will learn the following.

Use a code first approach to create a database model
Apply migrations to your database to apply your code model to your database
Configure your database using data annotations and a fluent API
Work with LINQ to perform database queries
Create a repository layer to manage your queries in code
Add, update and delete your database objects

Who this course is for:

Beginner to Advanced .NET developers

Complete guide to Entity Framework Core

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 5min

Starting with Entity Framework6 lectures • 27min

Applying migrations and tweaking the data model10 lectures • 39min

Working with multiple models - Navigation properties5 lectures • 38min

Manipulating the database using the fluent API8 lectures • 39min

Manipulating data6 lectures • 46min

Repository Layer7 lectures • 41min

LINQ4 lectures • 24min

Course Summary1 lecture • 2min

Requirements

Description

Who this course is for: