Entity Framework Core: Getting Started
This course will teach you how to use Entity Framework Core 5 to perform data access in your .NET applications.
What you'll learn
In this course, Entity Framework Core: Getting Started, you’ll learn to work with data in your .NET applications. First, you’ll explore the benefits of using Microsoft’s ORM, EF Core 5, 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 Overview 2m
- Module Overview 1m
- What Is Entity Framework Core? 3m
- Getting the Correct Versions of .NET, SQL Server & Visual Studio for This Course 2m
- Setting up the Solution 5m
- Adding EF Core with the NuGet Package Manager 3m
- Creating the Data Model with EF Core 3m
- Specifying the Data Provider and Connection String 3m
- A Sneak Peek at Writing and Reading Data 4m
- Review and Resources 1m
- Introduction and Overview 1m
- Learning More About One-to-Many Relationships 4m
- EF Core’s Default Many-to-Many Mapping 4m
- Storing Additional Data with Many-to-Many Payloads 3m
- Configuring the Many-to-Many Payload 3m
- Migrating the Many-to-Many Payload 3m
- Adding a One-to-One Relationship 3m
- Visualizing How EF Core Sees Your Model 3m
- Review and Resources 2m
- Introduction and Overview 2m
- Looking at SQL Built by EF Core 4m
- Adding Logging to EF Core's Workload 6m
- Benefiting from Bulk Operations Support 4m
- Understanding the Query Workflow 4m
- Filtering in Queries 5m
- Aggregating in Queries 3m
- Updating Simple Objects 4m
- Deleting Simple Objects 3m
- Understanding Disconnected Scenarios 2m
- Persisting Data in Disconnected Scenarios 4m
- Enhancing Performance in Disconnected Apps with No-Tracking Settings 3m
- Review and Resources 2m
- Introduction and Overview 1m
- Inserting Related Data 5m
- Eager Loading Related Data 6m
- Projecting Related Data in Queries 4m
- Loading Related Data for Objects Already in Memory 4m
- Using Related Data to Filter Objects 1m
- Modifying Related Data 4m
- Working with Many-to-Many Relationships 7m
- Altering or Removing Many-to-Many Joins 3m
- Adding a Many-to-Many Payload to Existing Join Table & Data 3m
- Working with the Many-to-Many Payload Data 3m
- Persisting Data in One-to-One Relationships 5m
- Querying One-to-One Relationships 3m
- Review and Resources 3m
- Introduction and Overview 1m
- Adding the ASP.NET Core Project 4m
- Adding a Samurai Controller to the Project 3m
- Wiring up the ASP.NET Core App with the DbContext 9m
- Running the Controller to See the Output 2m
- Exploring and Debugging Insert, Update, & Delete Controller Methods 6m
- EF Core 5 in Blazor Apps 5m
- Review and Resources 2m
- Introduction and Overview 2m
- A Very Quick Testing Overview 2m
- Understanding What We Mean by “Testing EF Core” 2m
- Creating Your First Test and Using It Against the Database 5m
- Exploring Test Results & Performance Considerations 3m
- Using the InMemory Provider in Place of a Database Provider 3m
- Writing Your First Test with the InMemory Provider 4m
- Refactoring and Testing Some Console App Logic 4m
- Re-using an InMemory Provider Database 2m
- Testing EF Core in an ASP.NET Core App 3m
- Testing the API’s DbContext Configuration 2m
- Review and Resources 3m
About the author
Julie Lerman is a Microsoft MVP, .NET mentor and consultant who lives in the hills of Vermont. You can find Julie presenting on data access and other Microsoft .NET topics at user groups and conferences around the world. Julie is the author of the highly acclaimed "Programming Entity Framework (with a second edition coming soon) and authors the MSDN Magazine Data Points column.
