Entity Framework Core: Getting Started

By Julie Lerman
This course will teach you how to use Entity Framework Core 5 to perform data access in your .NET applications.
Play course overview
Course info
Rating
(147)
Level
Beginner
Updated
Dec 15, 2020
Duration
4h 23m
Table of contents
Course Overview
Course Overview 2m
Building Your First Application using EF Core
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
Controlling Database Creation and Schema
Introduction and Overview 1m Understanding EF Core Migrations 3m Adding Your First Migration 4m Inspecting Your First Migration 2m Using Migrations to Script or Directly Create the Database 4m Reverse Engineering an Existing Database 5m Review and Resources 2m
Defining Relationships in Your Model
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
Interacting with Your EF Core Data Model
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
Interacting with Related Data
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
Working with Views and Stored Procedures and Raw SQL
Introduction and Overview 1m Adding Views and Other Database Objects Using Migrations 4m Using Keyless Entities to Map to Views 4m Querying the Database Views 1m Querying with Raw SQL 5m Running Stored Procedure Queries with Raw SQL 2m Executing Non-Query Raw SQL Commands 3m Review and Resources 2m
Using EF Core with ASP.NET Core
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
Automated Testing with EF Core
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
Description
Course info
Rating
(147)
Level
Beginner
Updated
Dec 15, 2020
Duration
4h 23m
Description

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.

About the author
Julie Lerman
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.

More from the author
Preparing Your Move to Entity Framework Core 5: What’s New and What’s Improved
Beginner
1h 26m
May 18, 2021
Domain-Driven Design Fundamentals
Beginner
4h 47m
May 14, 2021
More courses by Julie Lerman
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Welcome to Pluralsight. My name is Julie Lerman, and you may know me as one of the most recognized authorities in the world on Entity Framework, Microsoft's data access platform for .NET developers. This course has been completely updated for EF Core 5.0, which was released in November 2020. If you're already using Entity Framework or an earlier version of EF Core, this course will help you learn how to leverage your existing knowledge to quickly get up to speed on the basics of EF Core 5.0. If you're brand new to EF, you'll learn these basics and get insights that will take you further than a standard baby steps lesson. Whether you're using .NET Core to build apps for Windows for the cloud or even to run cross‑platform, you can use EF Core for your data persistence. You'll learn how to build and interact with data models and set up logging to gain insights into how EF Core is interacting with your database. You'll learn how to get EF Core to use your own database logic, such as stored procedures, and how you can easily get EF Core to switch to an in‑memory database for fast and efficient automated testing. We'll then apply these lessons to use EF Core for data persistence in an ASP.NET Core API, which any front end can then connect to. While this course will use a familiar environment, Visual Studio 2019 on Windows, everything you learn here will apply to any of the environments or IDEs where you can build .NET Core software, including Visual Studio Code and JetBrains Rider on Mac or Linux. I hope you'll join me on this journey as you get up to speed on using and benefiting from Entity Framework Core 5.0.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT