Mastering Entity Framework Core with .NET 5 Online Course
Mastering Entity Framework Core with .NET 5 Online Course
This Mastering Entity Framework Core with .NET 5 Online Course begins with an introduction to Entity Framework Core, followed by an update on .NET 8, preparing you for a comprehensive exploration of EF Core. It guides you through environment setup, project configuration in Visual Studio and Visual Studio Code, and foundational concepts like data models and database context. You'll learn about code-first development, migrations, and reverse-engineering an existing database. The course covers database querying techniques, from basic filters to advanced performance optimizations. You'll also explore data manipulation, handling database changes, and managing migrations. A focus on database relationships, raw SQL, views, stored procedures, and EF Core integration with ASP.NET Core follows. The course concludes with practical skills in data validation, transactions, and concurrency management.
Key Benefits
- In-depth exploration of EF Core concepts, progressing from foundational to advanced topics.
- A thorough examination of techniques for querying, manipulating data, and managing database modifications.
- Practical application of EF Core integration with ASP.NET Core, strengthening web development capabilities.
Target Audience
This course is perfect for students looking to gain practical, hands-on experience with Entity Framework Core. It is tailored for those who want to deeply understand the core functionality of EF Core, focusing on database interactions rather than design patterns or user interface development. A solid understanding of C# is essential, as it is the primary language used alongside EF Core. Additionally, a foundational knowledge of database development will be beneficial for grasping the course material effectively.
Learning Objectives
- Set up and configure the development environment for working with Entity Framework Core.
- Master the creation, querying, and manipulation of databases using EF Core techniques.
- Gain a deep understanding of various database relationships and loading methods, and how to implement them.
- Execute advanced querying using LINQ and raw SQL to efficiently retrieve and manipulate data within EF Core.
- Seamlessly integrate EF Core with ASP.NET Core to build dynamic, data-driven web applications.
- Effectively manage database changes and migrations, ensuring smooth transitions and updates to your data model.
Course Topics
The Mastering Entity Framework Core with .NET 5 Online Course covers the following topics -
1. Introduction
- Overview of the Course
- Defining Entity Framework Core
2. Setting Up the Environment
- Exploring the Required Tools
- How to Install Visual Studio (Windows)
- Visual Studio Code Installation Guide
- Installing .NET Core and EF Core Tools
3. Getting Started with Entity Framework Core
- Course Overview
- Creating a Project in Visual Studio
- Setting Up a Project Using Visual Studio Code and Dotnet CLI
- Understanding Data Models
- Designing Data Models with EF Core
- Introduction to Database Context
- How to Add a Database Context
- EF Core Database Compatibility
- Configuring Data Provider and Connection Strings
- Understanding Code-First and Migration Approaches
- Setting Up a Console Application Project
- How to Add and Use Migrations
- Database Generation with Code-First
- Understanding the Database-First Approach
- Reverse Engineering an Existing Database
- Seeding Data into the Database
4. Querying Databases with Entity Framework Core
- Overview of Querying Techniques
- Enabling Verbose Logging for EF Core Operations
- Refactoring Database Connection String
- Using LINQ for EF Core Queries
- Basic Querying Techniques
- Synchronous vs. Asynchronous Queries in EF Core
- Querying for a Single Record
- Applying Filters in Queries
- Advanced Filtering Techniques
- Alternative Approaches to LINQ Syntax
- Using Aggregate Functions in Queries
- Grouping Results with LINQ
- Sorting Data with OrderBy
- Implementing Skip and Take for Pagination
- Working with Projections and Custom Data Types
- Comparing Tracking vs. No Tracking for Performance
- IQueryables vs. Lists in EF Core
- Query Optimization Best Practices
5. Data Manipulation in Entity Framework Core
- Overview of Data Manipulation Techniques
- Understanding Change Tracking and Saving Data
- Performing Insert Operations
- Updating Data with EF Core
- Deleting Data in EF Core
- ExecuteUpdate and ExecuteDelete (EF Core 7+)
6. Handling Database Migrations and Changes
- Introduction to EF Core Migrations
- Adding New Entities to the Database
- Applying Migrations to Update Databases
- Working with Configuration Files
- Generating and Applying Migration Scripts
- Rolling Back Migrations and Changes
- Introduction to EF Core Bundles
- Managing Migrations During Runtime
7. Managing Related Data in Entity Framework Core
- Overview of Database Relationships
- Working with One-to-Many Relationships
- Setting Up One-to-Many Relationships
- Visualizing Data with EF Core Tools
- Managing Many-to-Many Relationships
- Implementing Many-to-Many Relationships
- One-to-One Relationships in EF Core
- Configuring One-to-One Relationships
- Updating Databases with Relationship Data
- Inserting Related Data into Database
- Exploring Loading Techniques in EF Core
- Eager Loading for Related Data
- Explicit Loading for Related Data
- Lazy Loading for Related Data
- Filtering Data in Related Tables
- Working with Projections and Anonymous Types
- Understanding Deletion Behaviors in Relationships
8. Working with Raw SQL, Views, and Stored Procedures
- Overview of Using Raw SQL in EF Core
- Creating Non-Table Objects via Migrations
- Querying Keyless Entities like Views
- Working with Raw SQL in Queries - Part 1
- Advanced Raw SQL Queries - Part 2
- Querying Scalar Data in EF Core
- Using User-defined Functions in SQL
- Understanding Limitations of Raw Queries in EF Core
9. Integrating EF Core with ASP.NET Core
- How EF Core Works with ASP.NET Core
- Setting Up an ASP.NET Core Project
- Configuring the Database Context in ASP.NET Core
- Resolving EF Core Design-Time Issues
- Scaffolding Code Using Visual Studio
- Scaffolding Code with Visual Studio Code
- Analyzing Scaffolded Code
- Reviewing Best Practices in Code Scaffolding
10. Advanced Features and Considerations
- Overview of Additional EF Core Features
- Manipulating Entries Before Committing Changes
- Working with SQL Server Temporal Tables
- Validating Data with Annotations
- Customizing Model Configuration
- Handling Database Transactions
- Resolving Data Concurrency Conflicts
- Implementing Global Query Filters
- Configuring Connection Retry and Timeout Strategies
