Entity Framework Core

1. Prerequisites#

• Getting Started with C# .NET

2. Object-Relational Mapping Explained for EVERYONE (with Code Examples)#

• Intro
• Prepare the Model (the Object)
• Preparing the Web API Controller
• Add the Object-Relational Mapper/ORM Entity Framework 7
• Use Code-First Migrations
• See Mapped Table in SQL Server
• Implement receiving the data from the database

3. Persist and retrieve relational data with Entity Framework Core

• Introduction
• Understanding EF Core
• Exercise - Migrations
• Exercise - Interacting with data
• Exercise - Run the app
• Exercise - Reverse engineering
• Summary

4. .NET 7 & Entity Framework 7: Mastering ALL Database Relationships (1:1, 1:n, n:n) with SQL Server#

• Intro
• Entity Framework & SQL Server Preparations
• Implement DbContext
• ConnectionString
• Register the DbContext
• One-to-one Relationship
• One-to-many Relationship
• Many-to-many Relationship
• Add a Controller
• Add DTOs
• Create a new Character
• Get a single character with all relationships

5. Cursor- vs. Offset-Pagination with Entity Framework in .NET 7#

• Intro
• Project Setup
• Benchmark #1: Access the Last Page
• Benchmark #2: Skip through All Pages
• Conclusion

6. Multiple Databases, DbContexts & Relationships (Entity Framework 7)#

• Project Overview
• Configure Multiple DbContexts
• Relationships between Databases (with Code-First Migrations)
• Update the Databases
• Little Fix
• Get related Data
• Implement an API Controller

Learn More:

• Entity Framework Core