Entity Framework Core - A Full Tour

1. Introduction

Kick off your journey into Entity Framework Core, setting the stage for an in-depth learning experience.

2. What is Entity Framework Core?

Gain a foundational understanding of Entity Framework Core and its role in .NET applications.

1. Toolset Overview

Explore the essential tools and software needed for effective Entity Framework Core development.

2. Install Visual Studio - Windows

Step-by-step guidance on installing Visual Studio on Windows for Entity Framework Core development.

3. Install Visual Studio Code

Step-by-step guidance on installing Visual Studio on Windows for Entity Framework Core development.

4. Install .NET Core and EF Core Tools

Get up and running with .NET Core and Entity Framework Core tools, essential for your development toolkit.

1. Section Overview

An overview of what to expect in this comprehensive section on starting with Entity Framework Core.

2. Setup Project Solution - Visual Studio

Learn to set up your Entity Framework Core project solution using Visual Studio.

3. Setup Project Solution - Visual Studio Code + Dotnet CLI

Discover how to establish your project using Visual Studio Code and the Dotnet CLI.

4. What are Data Models?

Understand the concept and significance of data models in Entity Framework Core.

5. Creating the Data Models with EF Core

Step into creating effective data models using Entity Framework Core.

6. Understanding the Database Context

Grasp the critical aspect of the database context in Entity Framework Core.

7. Adding a Database Context

Learn the practical steps to add a database context in your Entity Framework Core project.

8. EF Core and Database Support

Explore the range of databases supported by Entity Framework Core and their integrations.

9. Specifying the Data Provider and Connection String

Master the process of specifying data providers and connection strings in Entity Framework Core.

10. Understanding Code First Development and Migrations

Dive into the 'Code First' development approach and the migration process in EF Core.

11. Setup Console App Project

Learn to set up a console application project as part of your Entity Framework Core learning.

12. Adding a Migration

Get hands-on experience in adding a migration to your Entity Framework Core project.

13. Generating a Database (Code-First)

Understand the process of generating a database using the Code-First approach in EF Core.

14. Understanding Database First Development

Discover the 'Database First' development approach in Entity Framework Core.

15. Reverse Engineer Existing Database

Learn to reverse-engineer an existing database in the context of Entity Framework Core.

16. Seeding Data

Get acquainted with the process of seeding data into your databases using Entity Framework Core.

17. Section Review

Reflect on the key takeaways from the section about getting started with Entity Framework Core.

1. Section Overview

An introductory overview of querying databases using Entity Framework Core.

2. Adding Verbose Logging to EF Core's Workload

Learn how to add verbose logging to monitor and debug EF Core's operations effectively.

3. Fix: Database Connection String Refactor

Master the process of refactoring database connection strings in EF Core applications.

4. LINQ as Entity Framework Core Syntax

Understand the application of LINQ as the primary syntax for querying in EF Core.

5. Querying Basics

Grasp the fundamental techniques of querying databases using Entity Framework Core.

6. Synchronous vs. Asynchronous Syntax

Differentiate between synchronous and asynchronous syntax in EF Core queries.

7. Querying for a Single Record

Learn the nuances of querying for individual records in a database using EF Core.

8. Add Filters to Queries

Enhance your queries with filtering techniques to retrieve specific data in EF Core.

9. Additional Filtering Features

Explore advanced filtering techniques for complex queries in this video.

10. Alternative LINQ Syntax

Discover alternative LINQ syntax for diverse querying scenarios.

11. Aggregate Methods

Use aggregate methods to summarize and analyze data sets.

12. Group By

In this video, you will learn to group data effectively for insightful analysis.

13. Order By

Organize query results using the 'Order By' clause.

14. Skip and Take

Implement pagination in queries with Skip and Take methods.

15. Projections and Custom Data Types

Create projections and use custom data types in queries.

16. Tracking Vs. No Tracking (Enhancing Performance)

Optimize performance with tracking and no-tracking queries.

17. IQueryables vs List Types

Compare IQueryable and List types for efficient data handling.

18. Efficient Querying Tips and Tricks

Essential tips for enhancing the efficiency of database queries.

19. Section Review

Review of key concepts and techniques from this Section.

1. Section Overview

An introductory overview of data manipulation using EF Core.

2. Understanding Tracking and Saving Changes

Learn about tracking changes and saving data in EF Core.

3. Simple Insert Operations

Master the basics of inserting data into databases with EF Core.

4. Simple Update Operations

Update records efficiently in databases using EF Core.

5. Simple Delete Operations

Learn how to delete records correctly using EF Core.

6. ExecuteUpdate and ExecuteDelete (>= EF Core 7)

Explore new methods in EF Core 7 for updating and deleting data.

7. Section Review

A comprehensive review of data manipulation concepts in EF Core.

1. Section Overview

Introduction to managing database changes and migrations in EF Core.

2. Review Entity Framework Core Migrations

Deep dive into the mechanisms and functionalities of EF Core migrations.

3. Adding More Entities

Learn to add and integrate more entities into your EF Core model.

4. Updating Database with Migration(s)

Update databases effectively using migration techniques.

5. Using Configuration Files

Utilize configuration files for efficient database management.

6. Generating Migration Scripts

Generate scripts to automate and manage database migrations.

7. Rolling Back Migrations and Database Changes

Master the rollback of migrations and database changes for safety.

8. EF Bundles

Explore EF Bundles for simplified database management.

9. Applying Migrations at Runtime

Learn to apply migrations dynamically during runtime.

10. Section Review

Review and consolidate knowledge gained in this section.

1. Section Overview

An introductory guide to interacting with related records in EF Core.

2. Database Relationships and Entity Framework Core

Understand how to handle database relationships within EF Core.

3. One to Many Relationships

Explore the concept and application of one-to-many relationships.

4. Adding One-To-Many Relationships

Learn to add and manage one-to-many relationships effectively.

5. View Diagram with Entity Framework Core Tools

Visualize database relationships using EF Core tooling.

6. Many to Many Relationships

Understand and implement many-to-many relationships in EF Core.

7. Adding Many-To-Many Relationships

Detailed walkthrough of adding many-to-many relationships.

8. Understanding One-To-One Relationships

Comprehend the nuances of one-to-one relationships in databases.

9. Adding One-To-One Relationships

Learn how to add and manage one-to-one relationships in EF Core.

10. Update Database With Relationships

Update your database effectively to reflect new relationships.

11. Inserting Related Data

This video demonstrates the techniques for inserting data into related tables.

12. Understanding Loading Methods

Overview of different data loading methods in EF Core.

13. Including Related Data with Eager Loading

Implement eager loading to include related data efficiently.

14. Including Related Data with Explicit Loading

Learn explicit loading for more control over data retrieval.

15. Including Related Data with Lazy Loading

Master lazy loading for on-demand data retrieval in EF Core.

16. Filtering on Related Records

Filter data effectively while working with related records.

17. Projections and Anonymous Data Types

Utilize projections and anonymous types for optimized queries.

18. Understanding Delete Behaviors

Understand and handle various delete behaviors in relational data.

19. Section Review

Review of key concepts and practices in managing related records.

1. Section Overview

Introduction to advanced SQL techniques within EF Core.

2. Adding Non-Table Objects with Migrations

Learn how to add non-table objects, like views, with migrations in EF Core.

3. Querying Keyless Entities (Like Views)

Master querying keyless entities such as database views.

4. Querying with Raw SQL - Part 1

Start querying databases directly using raw SQL in EF Core.

5. Querying with Raw SQL - Part 2

Advanced techniques in querying with raw SQL.

6. Querying scalar

Understand how to query scalar values directly from the database.

7. Executing User-defined Funcitons

Execute user-defined functions seamlessly within EF Core.

8. Limitations of Raw Queries and EF Core

Discover the limitations and considerations when using raw SQL queries.

9. Section Review

Review of querying techniques using raw SQL, views, and stored procedures.

1. Section Overview

Overview of integrating EF Core with ASP.NET Core.

2. How EF Core and ASP.NET Core Work

Dive into how EF Core and ASP.NET Core work together for web development.

3. Create ASP.NET Core Project

Step-by-step guide to creating an ASP.NET Core project with EF Core.

4. Connect to the Database Context

Connect your ASP.NET Core project to the EF Core database context.

5. Fixing EF Core Design Time Errors

Resolve common design-time errors in EF Core.

6. Scaffolding Code with Visual Studio

Learn scaffolding code with Visual Studio for efficient development.

7. Scaffolding Code with Visual Studio Code

Scaffolding code using Visual Studio Code and EF Core.

8. Exploring Scaffolded Code

Explore the structure and function of scaffolded code.

9. Review Best Practices

Discuss best practices for using EF Core with ASP.NET Core.

10. Section Review

Review key concepts in integrating EF Core with ASP.NET Core.

1. Section Overview

Introduction to advanced features in EF Core.

2. Manipulate Entries Before Saving Changes

Manipulate entity entries before committing changes to the database.

3. SQL Server Temporal Tables

Implement SQL Server temporal tables for historical data tracking.

4. Data Validation with Data Annotations

Validate data using data annotations within EF Core.

5. Pre-convention model configuration

Configure models before conventions apply in EF Core.

6. Support For Database Transactions

Learn to manage database transactions effectively.

7. Handling Data Concurrency Issues

Handle concurrency issues in your database with EF Core.

8. Using Query Filters

Filter queries efficiently using built-in query filters.

9. Database Connection Retry and Timeout Policies

Manage database connections with retry and timeout policies.

1. Conclusion

Final thoughts and key takeaways from the comprehensive Entity Framework Core course.