Entity Framework Core: Getting Started
This course will help those with experience in earlier versions of Entity Framework, and developers completely new to Entity Framework, learn how to build models with EF Core, how to use EF Core to interact with data, and more.
What you'll learn
Most software - whether for business or entertainment - is driven by data that users need to interact with. In this course, Entity Framework Core: Getting Started, you will learn how to use Microsoft's modern data access platform, Entity Framework Core. You will learn how to build data models, use EF Core to bridge your software with your data store, and how to incorporate all of this into desktop, mobile, and web applications. When you're finished with this course, you will have a foundational knowledge of Entity Framework Core that will help you as you move forward to build software in .NET, whether you are targeting Windows, OS X, or Linux. Software required: Visual Studio 2015 or Visual Studio 2017.
Table of contents
- Introduction 1m
- Course Overview 1m
- Module Overview 3m
- What Is Entity Framework? 6m
- What Is Entity Framework Core? 3m
- Where Can You Use EF Core? 2m
- EF6 Features Not Coming to EF Core 3m
- How Entity Framework Works 6m
- Familiar EF Features in EF Core 1m
- New Features of EF Core 4m
- What About EF6? 5m
- Review 1m
- Resources 0m
- Introduction 0m
- Overview 1m
- Setting up the Solution 2m
- Adding in the Domain Classes 2m
- Adding EF Core with the Nuget Package Manager 3m
- Adding EF Core via PowerShell Commands 1m
- Creating the Data Model 4m
- Specifying the Data Provider and Connection String 4m
- Understanding EF Core Migrations 2m
- Adding Your First Migration 5m
- Scripting Database Creation Script from the Migration 2m
- Creating the Database Directly from the Migration 4m
- Preparing Your System for .NET Core 3m
- Recreating the Model in .NET Core 3m
- Using EF Core Migrations in .NET Core CLI 6m
- Review 1m
- Resources 1m
- Introduction 0m
- Overview 1m
- Understanding Many-to-Many in EF Core 3m
- Creating a Many-to-Many Relationship 5m
- Creating a One-to-One Relationship 5m
- Scripting and Migrating the Database After the Model Changes 5m
- Understanding EF Core Migrations' Scaffolding Command 3m
- Scaffolding a Model from an Existing Database 6m
- Review 1m
- Resources 0m
- Introduction 0m
- Overview 2m
- Inserting Simple Objects 5m
- Batch Commands When Saving 2m
- Querying Simple Objects 4m
- So, You Don't Want Every Row? 5m
- Updating Simple Objects 3m
- Disconnected Updates 5m
- Deleting Objects with EF Core 4m
- Querying with Raw SQL and Stored Procedures 6m
- Custom Functions in LINQ to EF Queries 1m
- Executing Raw SQL for Non-query Commands 3m
- Review 3m
- Resources 0m
- Introduction 0m
- Overview 1m
- Changes to Solution Since Previous Module 2m
- Inserting Related Data - Basics 4m
- Querying Related Data: Eager Loading 5m
- Retrieving Related Data Using Projections 6m
- Explicitly Loading Related Data 3m
- Using Related Data to Filter Objects 2m
- EF Core's Disconnected Graph Behaviors 6m
- Changes and Additions to Change Tracker 7m
- Review 1m
- Resources 0m
- Introduction 0m
- Overview 1m
- Your EF Core Projects and ASP.NET Core 3m
- Understanding EF Core Integration with ASP.NET Core 5m
- Wiring up SamuraiContext and Web API 6m
- Designing EF Logic for Disconnected Access 6m
- Wiring up the Web API Controller 3m
- Watching the Web API in Action 3m
- Review 2m
- Resources 0m
- Introduction 1m
- Overview 2m
- EF Core with .NET Core csproj Support in Visual Studio 2017 4m
- Migrating the ASP.NET Core Solution Created in Visual Studio 2015 3m
- Switching to SQLite & Running EF Core Migrations in VS2017 5m
- Coding with EF Core in Visual Studio Code 2m
- EF Core & Visual Studio Code in Windows 4m
- Interacting with Raw Data While Still in Visual Studio Code 3m
- Coding & Debugging EF Core in OS X with PostgreSQL 6m
- Exploring Data Created by EF Core in OS X 4m
- Review 2m
- Key Takeaways About EF Core 2m
- Resources 0m
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.
