EF Core 6 Fundamentals
This course will teach you how to use Entity Framework Core 6 to perform data access in your .NET applications.
What you'll learn
In this course, Entity Framework Core 6 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 6, 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 . Finally, 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 Course 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 6 Packages 4m
- 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 Bulk Support 5m
- 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 7m
- Review And Resources 2m
- Introduction and Overview 1m
- Visualizing EF Core’s Interpretation of Your Data Model 4m
- Interpreting One-to-Many Relationships 7m
- Benefitting from Foreign Key Properties 6m
- Mapping Unconventional Foreign Keys 2m
- 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 3m
- 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 7m
- 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 6m
- 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 Raw SQL 4m
- Keeping Your Database Safe with Parameterized Raw SQL Queries 8m
- Adding Stored Procedures and Other Database Objects Using Migrations 6m
- Running Stored Procedure Queries with Raw SQL 3m
- Using Keyless Entities to Map to Views 6m
- Querying the Database Views 1m
- Executing Non-Query Raw SQL Commands 3m
- Review and Resources 2m
- Introduction and Overview 2m
- Reviewing EF Core’s Lifecycle in Disconnected Apps 3m
- Adding the ASP.NET Core Project 5m
- Adding an Author Controller to the Project 4m
- Wiring up the ASP.NET Core App with the DbContext 8m
- Running the Controller to See the Output and Logs 6m
- Refactoring the Controller to Align with Common Practices 5m
- Exploring and Debugging Insert, Update & Delete Controller Methods 7m
- Using Raw SQL for Controller Methods 2m
- 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 5m
- Exploring Test Results and Performance Considerations 3m
- Using the InMemory Provider in Place of a Database Provider 4m
- Refactoring and Testing Some Console App Logic 7m
- Testing EF Core in an ASP.NET Core App 4m
- Review and Resources 3m
- Introduction and Overview 2m
- Understanding How Project Nullability Affects EF Core’s String Mappings 4m
- Learning Some Additional Common Conventions and Mappings 6m
- Using Data Annotations to Describe Mappings 3m
- Persisting Enums with EF Core 1m
- Mapping “Unmappable” Property Types with Value Conversions 3m
- Applying Bulk Configurations and Conversions 3m
- Mapping Complex Types and Value Objects 3m
- Review and Resources 2m
- Introduction and Overview 1m
- Exploring ChangeTracker Entries for Overriding the SaveChanges Method 4m
- Updating Shadow Properties During SaveChanges 2m
- Using EF Core Pipeline Events 3m
- Using Interceptors to Inject Logic into EF Core’s Pipeline 3m
- Adding Query Hints to Commands and Other Interceptor Examples 4m
- 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