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 2: Getting Started
2h 42m
Description
Entity Framework Core 2 is the newest version of Microsoft's O/RM for performing database persistence in .NET-based software. EF Core is a lightweight and extensible version of Entity Framework that has been written from the ground up. Whether you are new to EF Core or looking to see how to shift your earlier EF experience to EF Core, this course can help you get started. First, you'll learn how to define an EF Core data model to act as a bridge between your .NET objects and your database. You'll then learn how to interact with the data model using EF Core's various APIs. Finally, you'll be shown how to incorporate this model into a desktop application based on the .NET Framework and a cross-platform ASP.NET Core MVC application. By the end of this course, you will be able to build .NET framework, or .NET Core software using EF Core 2. All coding will be done in Visual Studio 2017 in a Windows environment.
Table of contents
- Course Overview
- Introducing a New, Lighter Weight Version of EF
- Creating a Data Model and Database with EF Core
- Interacting with Your EF Core Data Model
- Querying and Saving Related Data
- Using EF Core in Your Applications
Entity Framework Core 2: Mappings
1h 59m
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 23m
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 13m
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 5m
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