We begin with an introduction to Entity Framework Core, followed by an essential update on .NET 8, setting the stage for the detailed exploration that follows. The course systematically guides you through the Environment Setup, ensuring you have the necessary tools and understanding to proceed. Begin with basic concepts and progressively advance to more complex topics. The course covers project setup in both Visual Studio and Visual Studio Code, explaining data models, database context, and database support in EF Core. You'll learn about code-first development, migrations, and even reverse engineering an existing database, providing a well-rounded understanding of database interactions using EF Core. Then we delve into querying a database, discussing everything from basics and filters to advanced querying techniques and performance enhancement tips. You'll gain insights into manipulating data, handling changes, and managing database migrations effectively. Next, we will take a deep dive into database relationships, and you'll explore various types of relationships and their practical implementation. As you'll work with raw SQL, views, stored procedures, and the integration of EF Core with ASP.NET Core. The course concludes with a look at data validation, database transactions, and handling data concurrency issues.
Entity Framework Core - A Full Tour
Beginner
11h
By: Trevoir Williams
Overview
Modules
1. Chapter 1: Introduction
1.1 Introduction2 min
1.2 What is Entity Framework Core?8 min
2. Chapter 2: Environment Setup
2.1 Toolset Overview3 min
2.2 Install Visual Studio – Windows2 min
2.3 Install Visual Studio Code2 min
2.4 Install .NET Core and EF Core Tools3 min
3. Chapter 3: Getting Started with Entity Framework Core
3.1 Section Overview1 min
3.2 Setup Project Solution - Visual Studio2 min
3.3 Setup Project Solution - Visual Studio Code + Dotnet CLI7 min
3.4 What are Data Models?2 min
3.5 Creating the Data Models with EF Core9 min
3.6 Understanding the Database Context4 min
3.7 Adding a Database Context4 min
3.8 EF Core and Database Support5 min
3.9 Specifying the Data Provider and Connection String6 min
3.10 Understanding Code First Development and Migrations4 min
3.11 Setup Console App Project4 min
3.12 Adding a Migration8 min
3.13 Generating a Database (Code-First)4 min
3.14 Understanding Database First Development2 min
3.15 Reverse Engineer Existing Database8 min
3.16 Seeding Data8 min
3.17 Section Review3 min
4. Chapter 4: Using Entity Framework Core to Query a Database
4.1 Section Overview1 min
4.2 Quick Fix for SQL light for No Such Table Exists5 min
4.3 Adding Verbose Logging to EF Core's Workload3 min
4.4 LINQ as Entity Framework Core Syntax2 min
4.5 Querying Basics7 min
4.6 Synchronous vs. Asynchronous Syntax3 min
4.7 Querying for a Single Record15 min
4.8 Add Filters to Queries10 min
4.9 Additional Filtering Features9 min
4.10 Alternative LINQ Syntax5 min
4.11 Aggregate Methods6 min
4.12 Group By11 min
4.13 Order By7 min
4.14 Skip and Take12 min
4.15 Projections and Custom Data Types9 min
4.16 Tracking Vs. No Tracking4 min
4.17 IQueryables vs List Types11 min
4.18 Efficient Querying Tips and Tricks4 min
4.19 Section Review3 min
5. Chapter 5: Using Entity Framework Core to Manipulate Data
5.1 Section Overview1 min
5.2 Understanding Tracking and Saving Changes5 min
5.3 Simple Insert Operations13 min
5.4 Simple Update Operations10 min
5.5 Simple Delete Operations2 min
5.6 ExecuteUpdate and ExecuteDelete7 min
5.7 Section Review1 min
6. Chapter 6: Handling Database Changes and Migrations
6.1 Section Overview1 min
6.2 Review Entity Framework Core Migrations4 min
6.3 Adding More Entities6 min
6.4 Updating Database with Migration(s)13 min
6.5 Using Configuration Files7 min
6.6 Generating Migration Scripts7 min
6.7 Rolling Back Migrations and Database Changes7 min
6.8 EF Bundles4 min
6.9 Applying Migrations at Runtime4 min
6.10 Section Review2 min
7. Chapter 7: Interacting With Related Records
7.1 Section Overview1 min
7.2 Database Relationships and Entity Framework Core3 min
7.3 One to Many Relationships3 min
7.4 Adding One-To-Many Relationships7 min
7.5 View Diagram with Entity Framework Core Tools4 min
7.6 Many to Many Relationships5 min
7.7 Adding Many-To-Many Relationships11 min
7.8 Understanding One-To-One Relationships4 min
7.9 Adding One-To-One Relationships4 min
7.10 Update Database With Relationships13 min
7.11 Inserting Related Data14 min
7.12 Understanding Loading Methods3 min
7.13 Including Related Data with Eager Loading10 min
7.14 Including Related Data with Explicit Loading7 min
7.15 Including Related Data with Lazy Loading8 min
7.16 Filtering on Related Records7 min
7.17 Projections and Anonymous Data Types9 min
7.18 Understanding Delete Behaviors7 min
7.19 Section Review4 min
8. Chapter 8: Working With Raw SQL, Views and Stored Procedures
8.1 Section Overview1 min
8.2 Adding Non-Table Objects with Migrations4 min
8.3 Querying Keyless Entities (Like Views)7 min
8.4 Querying with Raw SQL8 min
8.5 Querying with Raw SQL Part 29 min
8.6 Querying scalar2 min
8.7 Executing User-defined Functions6 min
8.8 Limitations of Raw Queries and EF Core1 min
8.9 Section Review2 min
9. Chapter 9: ASP.NET Core and EF Core
9.1 Section Overview1 min
9.2 How EF Core and ASP.NET Core Work5 min
9.3 Create ASP.NET Core Project7 min
9.4 Connect to the Database Context10 min
9.5 Fixing EF Core Design Time Errors15 min
9.6 Scaffolding Code with Visual Studio5 min
9.7 Scaffolding Code with Visual Studio Code3 min
9.8 Exploring Scaffolded Code7 min
9.9 Review Best Practices9 min
9.10 Section Review3 min
10. Chapter 10: Additional Features and Considerations
10.1 Section Overview1 min
10.2 Manipulate Entries Before Saving Changes14 min
10.3 SQL Server Temporal Tables15 min
10.4 Data Validation with Data Annotations8 min
10.5 Pre-convention model configuration2 min
10.6 Support For Database Transactions9 min
10.7 Handling Data Concurrency Issues13 min
10.8 Using Query Filters9 min
10.9 Database Connection Retry and Timeout Policies6 min
11. Chapter 11: Conclusion
11.1 Conclusion4 min
Ready to Elevate Your Team's Learning?
Talk with our sales team to see how StormWind can transform the way your organization trains and grows.
CONTACT SALES