EF Core 8 Fundamentals
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.
Table of contents
- Introduction and Overview 4m
- What Is Entity Framework Core? 3m
- Getting the Correct Versions of .NET, SQL Server and Visual Studio for this Course 2m
- Introducing the Project 3m
- Creating a Data Project with EF Core Packages 3m
- Creating the Data Model with EF Core 3m
- Specifying the Data Provider and Connection String 3m
- Reading and Writing Some Data 5m
- Reading and Writing Some Related Data 4m
- Review and Resources 1m
- Introduction and Overview 1m
- Gaining a Better Understanding of DbContext and Entity 3m
- Understanding Tracking and Saving Workflow 2m
- Inserting Simple Objects 3m
- Updating Simple Objects 8m
- Updating Untracked Objects 5m
- Deleting Simple Objects 4m
- Tracking Multiple Objects and Batch Support 3m
- Updating and Deleting Multiple Untracked Objects 6m
- Review and Resources 2m
- Introduction and Overview 1m
- Understanding EF Core Migrations 2m
- Getting and Understanding the Design-Time Migrations Tools 5m
- Getting the Package Manager Console Ready to Use Migrations 3m
- Adding Your First Migration 2m
- Inspecting Your First Migration 4m
- Using Migrations to Script or Directly Create the Database 5m
- Seeding a Database via Migrations 5m
- Scripting Multiple Migrations 4m
- Reverse Engineering an Existing Database 8m
- Review and Resources 2m
- Introduction and Overview 1m
- Visualizing EF Core’s Interpretation of Your Data Model 4m
- Interpreting One-to-Many Relationships 7m
- Benefiting from Foreign Key Properties 6m
- Mapping Unconventional Foreign Keys 3m
- Understanding Nullability and Required vs. Optional Principals 3m
- Review and Resources 2m
- Introduction and Overview 2m
- Adding Related Data 8m
- Eager Loading Related Data in Queries 6m
- Projecting Related Data in Queries 4m
- Loading Related Data for Objects Already in Memory 2m
- Using Lazy Loading to Retrieve Related Data 4m
- Using Related Data to Filter Objects 2m
- Modifying Related Data 6m
- Understanding Deleting Within Graphs 8m
- Review and Resources 2m
- Introduction and Overview 1m
- Planning the Many-to-Many Implementation 3m
- Understanding and Creating Skip Navigations 7m
- Joining Objects in New Many-to-Many Relationships 6m
- Querying Across Many-to-Many Relationships 3m
- Understanding and Benefiting From Circular References in Graphs 5m
- Removing Joins in Many-to-Many Relationships 5m
- Changing Joins in Many-to-Many Relationships 2m
- Introducing More Complex Many-to-Many Relationships 6m
- Review and Resources 2m
- Introduction and Overview 1m
- Understanding How EF Core Discovers One-to-One Relationships 5m
- Updating the Model and Database with the New Relationship 7m
- Querying One-to-One Relationships 6m
- Combining Objects in One-to-One Relationships 5m
- Replacing or Removing One-to-One Relationships 3m
- Review and Resources 3m
- Introduction and Overview 2m
- Querying with SQL 4m
- Keeping Your Database Safe with Parameterized Raw SQL Queries 8m
- Adding Stored Procedures and Other Database Objects Using Migrations 5m
- Running Stored Procedure Queries with Raw SQL 4m
- Querying for Scalars and Other Non-Entity Types 5m
- Using Keyless Entities to Map to Views 6m
- Querying the Database Views 1m
- Executing Non-Query SQL Commands 4m
- Mapping Insert, Update, and Delete Stored Procedures to Entities 6m
- Review and Resources 2m
- Introduction and Overview 2m
- Reviewing EF Core’s Lifecycle in Disconnected Apps 3m
- Adding the ASP.NET Core Project 5m
- Creating Author Endpoints for the API 7m
- Wiring up the ASP.NET Core App with the DbContext 8m
- Running the API to See the Output and Logs 7m
- Refactoring the API to Align with Common Practices Using DTOs 5m
- Exploring and Debugging Insert, Update & Delete API Methods 7m
- Review and Resources 2m
- Introduction and Overview 2m
- A Very Quick Testing Overview 2m
- Understanding What We Mean by “Testing EF Core” 2m
- Preparing the DbContext 2m
- Creating Your First Test and Using It Against the Database 6m
- Exploring Test Results and Performance Considerations 4m
- Testing with SQLite in Memory 6m
- Refactoring and Testing Some Console App Logic 6m
- Testing the ASP.NET Core API 3m
- Testing Endpoints That Use EF Core 5m
- Review and Resources 2m
- Introduction and Overview 2m
- Understanding How Project Nullability Affects EF Core’s String Mappings 4m
- Learning Some Additional Common Conventions and Mappings 7m
- Using Data Annotations to Describe Mappings 2m
- Storing Sub-Types and Primitive Collections as JSON 2m
- Mapping “Unmappable” Property Types with Value Conversions 3m
- Applying Bulk Configurations and Conversions 3m
- Mapping Complex Types and DDD Value Objects 3m
- Review and Resources 2m
About the author
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 E... more