Log In
Start
Free
Trial
Log In
Start
Free
Trial
Back To Course Home
Using Entity Framework Core for Data Access & Relational Mapping
0% completed
Getting Started
Introduction to Entity Framework Core
Features of Entity Framework Core
Reverse Engineering
Scaffolding a Model from a Database Schema
Reviewing and Modifying the Scaffolded Model
Quiz: Reverse Engineering
Challenge: Reverse Engineering
Challenge Solution: Reverse Engineering
Migrations
Introduction to Migrations
Using Migrations in a Production Database
Modifying the Data Model
Data Seeding and Custom Migrations
Handling Mistakes and Avoiding Pitfalls
Quiz: Migrations
Challenge: Migrations
Challenge Solution: Migrations
Configuring a Model
Conventions in Entity Framework Core
Supplementing Conventions in Entity Framework Core
Configuring Entity Types
Configuring Entity Properties
Relationships in Entity Framework Core
Configuring One-to-Many Relationships
Configuring One-to-One Relationships
Configuring Many-to-Many Relationships
Quiz: Configuring a Model
Challenge: Configuring a Model
Challenge Solution: Configuring a Model
Query Data
Querying Data with LINQ
LINQ Query Operations
Filtering and Ordering Operations
Projection and Grouping Query Operations
Partitioning and Element Operations
Quantifier and Aggregation Operations
Loading Related Data
Equi join Operations
Custom Join Operations
Raw SQL Queries and Split Queries
Global Query Filters
Quiz: Query Data
Challenge: Query Data
Challenge Solution: Query Data
Save Data
Adding, Updating, and Deleting Data
Change Tracking
Disconnected Entities
Quiz: Save Data
Challenge: Save Data
Challenge Solution: Save Data
Logging and Testing
Logging with Entity Framework Core
Filtering Logs in Entity Framework Core
Quiz: Logging
Testing with SQLite
Testing with the Repository Pattern
Quiz: Testing
Conclusion
Wrap Up!
Appendix
Installing Entity Framework Core
LINQ Query Operations
Learn the basics of LINQ query operations.
We'll cover the following
Overview
Defining a data source
Defining the query
The query variable
The query expression
Executing the query
Deferred execution
Forcing immediate execution
Writing query expressions
Differences between query and method syntaxes
Get hands-on with 1200+ tech skills courses.
Start Free Trial