Entity Framework Core - A Full Tour

Table of contents

1. Introduction
   1. Introduction to the Course
   2. What is Entity Framework Core?
2. Environment Setup
   1. Toolset Overview
   2. Install Visual Studio - Windows
   3. Install Visual Studio Code
   4. Install .NET Core and EF Core Tools
3. Getting Started with Entity Framework Core
   1. Section Overview
   2. Setup Project Solution - Visual Studio
   3. Setup Project Solution - Visual Studio Code + Dotnet CLI
   4. What are Data Models?
   5. Creating the Data Models with EF Core
   6. Understanding the Database Context
   7. Adding a Database Context
   8. EF Core and Database Support
   9. Specifying the Data Provider and Connection String
   10. Understanding Code First Development and Migrations
   11. Setup Console App Project
   12. Adding a Migration
   13. Generating a Database (Code-First)
   14. Understanding Database First Development
   15. Reverse Engineer Existing Database
   16. Seeding Data
   17. Section Review
4. Using Entity Framework Core to Query a Database
   1. Section Overview
   2. Adding Verbose Logging to EF Core’s Workload
   3. Fix: Database Connection String Refactor
   4. LINQ as Entity Framework Core Syntax
   5. Querying Basics
   6. Synchronous vs. Asynchronous Syntax
   7. Querying for a Single Record
   8. Add Filters to Queries
   9. Additional Filtering Features
   10. Alternative LINQ Syntax
   11. Aggregate Methods
   12. Group By
   13. Order By
   14. Skip and Take
   15. Projections and Custom Data Types
   16. Tracking Vs. No Tracking (Enhancing Performance)
   17. IQueryables vs List Types
   18. Efficient Querying Tips and Tricks
   19. Section Review
5. Using Entity Framework Core to Manipulate Data
   1. Section Overview
   2. Understanding Tracking and Saving Changes
   3. Simple Insert Operations
   4. Simple Update Operations
   5. Simple Delete Operations
   6. ExecuteUpdate and ExecuteDelete (>=EF Core 7)
   7. Section Review
6. Handling Database Changes and Migrations
   1. Section Overview
   2. Review Entity Framework Core Migrations
   3. Adding More Entities
   4. Updating Database with Migration(s)
   5. Using Configuration Files
   6. Generating Migration Scripts
   7. Rolling Back Migrations and Database Changes
   8. EF Bundles
   9. Applying Migrations at Runtime
   10. Section Review
7. Interacting With Related Records
   1. Section Overview
   2. Database Relationships and Entity Framework Core
   3. One to Many Relationships
   4. Adding One-To-Many Relationships
   5. View Diagram with Entity Framework Core Tools
   6. Many to Many Relationships
   7. Adding Many-To-Many Relationships
   8. Understanding One-To-One Relationships
   9. Adding One-To-One Relationships
   10. Update Database With Relationships
   11. Inserting Related Data
   12. Understanding Loading Methods
   13. Including Related Data with Eager Loading
   14. Including Related Data with Explicit Loading
   15. Including Related Data with Lazy Loading
   16. Filtering on Related Records
   17. Projections and Anonymous Data Types
   18. Understanding Delete Behaviors
   19. Section Review
8. Working With Raw SQL, Views and Stored Procedures
   1. Section Overview
   2. Adding Non-Table Objects with Migrations
   3. Querying Keyless Entities (Like Views)
   4. Querying with Raw SQL - Part 1
   5. Querying with Raw SQL - Part 2
   6. Querying scalar
   7. Executing User-defined Funcitons
   8. Limitations of Raw Queries and EF Core
   9. Section Review
9. ASP.NET Core and EF Core
   1. Section Overview
   2. How EF Core and ASP.NET Core Work
   3. Create ASP.NET Core Project
   4. Connect to the Database Context
   5. Fixing EF Core Design Time Errors
   6. Scaffolding Code with Visual Studio
   7. Scaffolding Code with Visual Studio Code
   8. Exploring Scaffolded Code
   9. Review Best Practices
   10. Section Review
10. Additional Features and Considerations
    1. Section Overview
    2. Manipulate Entries Before Saving Changes
    3. SQL Server Temporal Tables
    4. Data Validation with Data Annotations
    5. Pre-convention model configuration
    6. Support For Database Transactions
    7. Handling Data Concurrency Issues
    8. Using Query Filters
    9. Database Connection Retry and Timeout Policies
11. Conclusion
    1. Conclusion