Paths
Entity Framework Core
Entity Framework Core (EF Core) is Microsoft's object-relational mapper (O/RM) that can help you quickly build data access layers for your applications. In this path, you will... Read more
What you will learn
- Creating data models in EF Core
- Interacting with data models in EF Core
- Querying and saving data
- Mapping relationships between objects
- Using lazy loading
- Using value converters to map .NET Types and enums
- Using EF Core with database views
- Managing your database using migrations
Pre-requisites
Familiarity with the C# language and basic relational database skills
Beginner
This set of courses gets you up and running with EF Core by covering the most common scenarios you encounter with EF Core. You will build a data model with EF Core, see how to query and save data and how to deal with complex mappings that come up when building an application.
Entity Framework Core: Getting Started
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.
Table of contents
- Course Overview
- Building Your First Application using EF Core
- Controlling Database Creation and Schema
- Defining Relationships in Your Model
- Interacting with Your EF Core Data Model
- Interacting with Related Data
- Working with Views and Stored Procedures and Raw SQL
- Using EF Core with ASP.NET Core
- Automated Testing with EF Core
Entity Framework Core 2: Mappings
1h 58m
Description
Entity Framework Core 2 is the latest version of Microsoft’s modern OR/M data access platform. In this course, Entity Framework Core 2: Mappings, you’ll explore how to efficiently utilize the latest version of Entity Framework Core to prepare yourself to work on production software. First, you’ll learn how to best build and interact with many-to-many and one-to-one relationships. Next, you'll discover how to take advantage of additional mappings such as the new shadow properties, scalar function support, and owned entities. Finally, you'll go over how to work with database views. By the end of this course, you'll be able to elevate your skill set and provide yourself with the tools you need to build your production application.
Table of contents
- Course Overview
- Getting to Know the Sample Model
- Mapping and Interacting with Many-to-many Relationships
- Mapping and Interacting with One-to-one Relationships
- Using Shadow Properties to Persist Data You Don’t Want in Your Entities
- Leveraging the New Owned Type Feature for Value Objects and Complex Types
- Mapping Database Scalar Functions
- Working with Database Views
Intermediate
EF Core contains many new features designed to help you deal with advanced scenarios, and that is what you will learn in this section. This includes tapping into the EF Core pipeline with tracking events, using query types to access database views and using value converters to intercept and process values as they are read out of the database.
Entity Framework Core 2.1: What's New Playbook
3h 22m
Description
Every application uses data, and a thorough knowledge of Entity Framework Core is key to building successful .NET and .NET Core applications. In this course, Entity Framework Core 2.1: What's New Playbook, you’ll learn how to take full advantage of the most impactful features added to EF Core 2 in this update. First, you’ll learn how to use some returning features that work quite differently than they did in EF6, for example, data seeding, lazy loading and GroupBy queries. Next, you’ll explore some completely new features such as view mapping, change tracking event handlers, and type conversions. Finally, you’ll discover some of the small changes that can have a big impact on your code. When you’re finished with this course, you’ll have a deep knowledge of these important features in EF Core 2.1, enhancing your capability to create efficient and intelligent data access logic in your software.
Table of contents
- Course Overview
- Setting the Stage for the EF Core 2.1 Release
- Seeding the Database and In-Memory Test Provider
- Exerting More Control Over Saving with System Transactions
- Tapping into the Pipeline with New Tracking Events
- Lazy Loading With and Without Proxies
- Mapping More .NET Types and Enums with Value Conversions
- Transferring the GroupBy Effort to the Server
- Introducing Query Types for More Flexible Data Models
- Benefiting from Minor Changes with Major Impact
Testing with EF Core
1h 12m
Description
In this course, Testing with EF Core, you will learn how EF Core can help with testing code that relies on calls into your database. First, you will learn about different ways of testing your application. Next, you will discover how in-memory database providers like InMemory and SQLite can help with improving your tests. Finally, you will explore how to isolate your tests and how to enhance Test Explorer with logs coming from EF Core. When you're finished with this course, you will have the skills and knowledge of EF Core needed to improve your tests and thus the reliability of your code.
Table of contents
- Course Overview
- Getting Started with EF Core Testing
- Unit Testing Your Code with EF Core InMemory
- Improving the Reliability of EF Core Testing with SQLite
Advanced
EF Core contains the capability to manage your database schema from code, and in this segment, you will do a deep dive on EF Migrations, the technology behind this capability.
Entity Framework Core 2.1 Migrations: Fundamentals
2h 4m
Description
Entity Framework Core Migrations are Microsoft's recommended way of managing application databases. They are extremely powerful, but you have to understand how to use them.
In this course, Entity Framework Core 2.1 Migrations: Fundamentals, you will learn the foundations of developing and deploying an enterprise application using migrations. First, you will learn how to create, test, and organize migrations. Next, you will discover how to resolve the conflicts that will inevitably arise. Finally, you will explore different methods of deploying database changes to higher environments, and determine which is most appropriate for going to production.
When you are finished with this course, you will have the skills and knowledge of EF Core Migrations needed to build and deploy enterprise applications.
Table of contents
- Course Overview
- Working with Migrations
- Separating Application Layers
- Resolving Conflicts
- Going to Production