EF Core 8 Fundamentals

Focused View

Julie Lerman

8:10:15

15 View

1. Course Overview

1. Course Overview.mp4

01:39

2. Creating Your First Application Using EF Core

1. Introduction and Overview.mp4

04:26

2. What Is Entity Framework Core.mp4

03:29

3. Getting the Correct Versions of .NET, SQL Server and Visual Studio for this Course.mp4

01:40

4. Introducing the Project.mp4

03:16

5. Creating a Data Project with EF Core Packages.mp4

03:13

6. Creating the Data Model with EF Core.mp4

03:08

7. Specifying the Data Provider and Connection String.mp4

03:11

8. Reading and Writing Some Data.mp4

04:50

9. Reading and Writing Some Related Data.mp4

03:41

10. Review and Resources.mp4

01:06

3. Using EF Core to Query a Database

1. Introduction and Overview.mp4

01:15

2. Querying Basics.mp4

06:37

3. Filtering Queries Securely by Default.mp4

04:34

4. Benefiting from Additional Filtering Features.mp4

05:37

5. Sorting Data in Queries.mp4

02:11

6. Aggregating Results in Queries.mp4

04:17

7. Enhancing Query Performance When Tracking Isnt Needed.mp4

03:59

8. Review and Resources.mp4

01:48

4. Tracking and Saving Data with EF Core

1. Introduction and Overview.mp4

01:22

2. Gaining a Better Understanding of DbContext and Entity.mp4

02:50

3. Understanding Tracking and Saving Workflow.mp4

02:20

4. Inserting Simple Objects.mp4

03:17

5. Updating Simple Objects.mp4

08:06

6. Updating Untracked Objects.mp4

04:49

7. Deleting Simple Objects.mp4

03:36

8. Tracking Multiple Objects and Batch Support.mp4

02:56

9. Updating and Deleting Multiple Untracked Objects.mp4

05:41

10. Review and Resources.mp4

01:48

5. Controlling Database Creation and Schema with Migrations

1. Introduction and Overview.mp4

01:09

2. Understanding EF Core Migrations.mp4

02:25

3. Getting and Understanding the Design-Time Migrations Tools.mp4

04:58

4. Getting the Package Manager Console Ready to Use Migrations.mp4

03:11

5. Adding Your First Migration.mp4

02:15

6. Inspecting Your First Migration.mp4

04:13

7. Using Migrations to Script or Directly Create the Database.mp4

05:14

8. Seeding a Database via Migrations.mp4

04:33

9. Scripting Multiple Migrations.mp4

03:51

10. Reverse Engineering an Existing Database.mp4

07:32

11. Review and Resources.mp4

01:44

6. Defining One-to-Many Relationships

1. Introduction and Overview.mp4

01:15

2. Visualizing EF Cores Interpretation of Your Data Model.mp4

03:38

3. Interpreting One-to-Many Relationships.mp4

06:46

4. Benefiting from Foreign Key Properties.mp4

05:52

5. Mapping Unconventional Foreign Keys.mp4

02:52

6. Understanding Nullability and Required vs. Optional Principals.mp4

02:40

7. Review and Resources.mp4

01:51

7. Logging EF Core Activity and SQL

1. Introduction and Overview.mp4

00:48

2. Adding Logging to EF Cores Workflow.mp4

02:50

3. Filtering Log Output with EF Core Message Categories and LogLevel.mp4

03:29

4. Additional Filtering Capabilities.mp4

02:35

5. Specifying the Target of the Log Output.mp4

01:29

6. Review and Resources.mp4

01:49

8. Interacting with Related Data

1. Introduction and Overview.mp4

01:44

2. Adding Related Data.mp4

07:57

3. Eager Loading Related Data in Queries.mp4

06:10

4. Projecting Related Data in Queries.mp4

03:34

5. Loading Related Data for Objects Already in Memory.mp4

02:18

6. Using Lazy Loading to Retrieve Related Data.mp4

04:02

7. Using Related Data to Filter Objects.mp4

01:32

8. Modifying Related Data.mp4

05:54

9. Understanding Deleting Within Graphs.mp4

08:06

10. Review and Resources.mp4

01:38

9. Defining and Using Many-to-Many Relationships

1. Introduction and Overview.mp4

01:24

2. Planning the Many-to-Many Implementation.mp4

03:02

3. Understanding and Creating Skip Navigations.mp4

06:45

4. Joining Objects in New Many-to-Many Relationships.mp4

05:48

5. Querying Across Many-to-Many Relationships.mp4

03:05

6. Understanding and Benefiting From Circular References in Graphs.mp4

05:18

7. Removing Joins in Many-to-Many Relationships.mp4

05:23

8. Changing Joins in Many-to-Many Relationships.mp4

01:40

9. Introducing More Complex Many-to-Many Relationships.mp4

06:21

10. Review and Resources.mp4

01:47

10. Defining and Using One-to-One Relationships

1. Introduction and Overview.mp4

01:05

2. Understanding How EF Core Discovers One-to-One Relationships.mp4

04:42

3. Updating the Model and Database with the New Relationship.mp4

06:48

4. Querying One-to-One Relationships.mp4

05:59

5. Combining Objects in One-to-One Relationships.mp4

04:35

6. Replacing or Removing One-to-One Relationships.mp4

03:27

7. Review and Resources.mp4

02:36

11. Working with SQL, Views, and Stored Procedures

1. Introduction and Overview.mp4

02:13

2. Querying with SQL.mp4

03:57

3. Keeping Your Database Safe with Parameterized Raw SQL Queries.mp4

08:07

4. Adding Stored Procedures and Other Database Objects Using Migrations.mp4

05:05

5. Running Stored Procedure Queries with Raw SQL.mp4

03:39

6. Querying for Scalars and Other Non-Entity Types.mp4

04:37

7. Using Keyless Entities to Map to Views.mp4

05:58

8. Querying the Database Views.mp4

01:28

9. Executing Non-Query SQL Commands.mp4

03:38

10. Mapping Insert, Update, and Delete Stored Procedures to Entities.mp4

05:32

11. Review and Resources.mp4

02:10

12. Using EF Core in ASP.NET Core Apps

1. Introduction and Overview.mp4

01:54

2. Reviewing EF Cores Lifecycle in Disconnected Apps.mp4

03:22

3. Adding the ASP.NET Core Project.mp4

04:40

4. Creating Author Endpoints for the API.mp4

07:19

5. Wiring up the ASP.NET Core App with the DbContext.mp4

07:32

6. Running the API to See the Output and Logs.mp4

06:59

7. Refactoring the API to Align with Common Practices Using DTOs.mp4

04:30

8. Exploring and Debugging Insert, Update & Delete API Methods.mp4

07:22

9. Review and Resources.mp4

02:04

13. Testing with EF Core

1. Introduction and Overview.mp4

01:51

2. A Very Quick Testing Overview.mp4

02:03

3. Understanding What We Mean by Testing EF Core.mp4

02:05

4. Preparing the DbContext.mp4

02:05

5. Creating Your First Test and Using It Against the Database.mp4

06:02

6. Exploring Test Results and Performance Considerations.mp4

04:15

7. Testing with SQLite in Memory.mp4

06:10

8. Refactoring and Testing Some Console App Logic.mp4

06:22

9. Testing the ASP.NET Core API.mp4

03:05

10. Testing Endpoints That Use EF Core.mp4

04:46

11. Review and Resources.mp4

02:28

14. Adding Some More Practical Mappings to Your Application

1. Introduction and Overview.mp4

02:20

2. Understanding How Project Nullability Affects EF Cores String Mappings.mp4

03:44

3. Learning Some Additional Common Conventions and Mappings.mp4

06:49

4. Using Data Annotations to Describe Mappings.mp4

02:27

5. Storing Sub-Types and Primitive Collections as JSON.mp4

02:03

6. Mapping Unmappable Property Types with Value Conversions.mp4

03:01

7. Applying Bulk Configurations and Conversions.mp4

03:09

8. Mapping Complex Types and DDD Value Objects.mp4

03:26

9. Review and Resources.mp4

01:53

15. Understanding EF Cores Database Connectivity

1. Introduction and Overview(1).mp4

01:27

2. Recognizing the Many Database Providers Available for EF Core.mp4

03:19

3. Highlights of the Azure Cosmos DB Provider.mp4

04:20

4. EF Cores Transaction Support and Concurrency Handling.mp4

05:03

5. Answering Some DB Connection FAQs.mp4

04:14

6. Review and Resources.mp4

01:52

16. Tapping into EF Cores Pipeline

1. Introduction and Overview.mp4

00:47

2. Exploring ChangeTracker Entries for Overriding the SaveChanges Method.mp4

03:36

3. Updating Shadow Properties During SaveChanges.mp4

02:40

4. Using EF Core Pipeline Events.mp4

03:08

5. Using Interceptors to Inject Logic into EF Cores Pipeline.mp4

03:30

6. Review and Resources.mp4

01:48

Description

This course will teach you how to use Entity Framework Core to perform data access in your .NET applications.

What You'll Learn?

If you are new to EF Core or have experience using an earlier version, this course will help you get up to speed on the basics of EF Core 8. In this course, EF Core 8 Fundamentals, you’ll learn to work with data in your .NET applications. First, you’ll explore the benefits of using Microsoft’s ORM, EF Core, to relieve you of the commonplace tasks of retrieving and storing data in your software. Next, you’ll discover how to ensure that EF Core understands how the classes and relationships in your software map to a database schema. You’ll learn how to have EF Core retrieve and persist data in your software, leveraging the myriad capabilities that allow EF Core to comprehend your complex software models. When you’re finished with this course, you’ll have the skills and knowledge of Entity Framework Core needed to fluidly persist data from your software into your data stores.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Programming Fundamentals

Object Oriented Programming

Functional Programming

Julie Lerman

Instructor's Courses

Julie Lerman is a software coach with over 30 years of experience building software. As a coach, Julie provides support for DDD and architecture implementation, facilitates Event Storming workshops and domain discovery. She also provides deep dives into Entity Framework for her clients in the .NET world. Julie is a long-time Pluralsight author, Microsoft MVP, Microsoft Regional Director and Docker Captain who lives in the hills of Vermont and continues to be known as the world’s top expert in Entity Framework. You can find Julie giving keynotes and hard-core coding sessions on Domain-Driven Design, Azure, Entity Framework and other topics at software conferences around the world. Julie has authored the highly acclaimed “Programming Entity Framework” books from O'Reilly, the MSDN Magazine Data Points column and numerous articles in your favorite programming resources.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.