TOIT Training

Facebook X-twitter Linkedin Instagram
Menu
Beginner
.NET Courses

Entity Framework Core - A Full Tour

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

Overview

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.

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below: