Premium Only Content

Entity Framework Core Part 4: Querying Related Data and Using Projections by Microsoft
In this episode, Robert is joined by Phil Japikse for part 4 of a 5 part series on Entity Framework Core. Aimed at folks new to EF Core, Phil shows how to start with an existing SQL Server database, create entities/objects for each table and then how to perform basic CRUD operations on the data.
Querying related data is simple in EF Core. In this episode we demonstrate creating joins in our LINQ queries with Include and ThenInclude. We also discuss how you use projections to shape the queried data into other objects, anonymous or strongly typed.
Find the sample code at https://github.com/skimedic/presentat....
Learn more about Entity Framework Core at https://aka.ms/vstefcoredocs.
Episode list:
Part 1: Working with Existing Databases. We scaffold the DbContext and the Entities from the Northwind Database, discuss navigation properties and relationships.
Part 2: Change Tracking. Change Tracking is one of the most compelling reasons to use an object-relational-mapper (ORM) like EF Core. In this episode we discuss how the change tracker works, see it in action, as well as load data outside of the change tracker.
Part 3: Basic Queries. This episode covers querying data using EF Core. We discuss the basics of Where clauses, retrieving single items or lists of items, as well as when queries actually execute.
Part 4: Querying Related Data and Using Projections (this episode).
Part 5: Putting the CUD into CRUD. Wrapping up our starter series on EF Core, this episode covers adding, updating, and deleting data.
----------------------------------------------------
Follow me @everse for more Technology and Gaming Updates!
### FIND THE BEST FREELANCE JOBS ###
FREELANCER: https://www.freelancer.com/get/emmanverz?f=give
FIVERR: https://www.fiverr.com/pe/moyegR
### CRYPTOCURRENCY EXCHANGE / TRADING ###
BINANCE: https://www.binance.com/en/activity/referral-entry/CPA?ref=CPA_00P8Q8YM46
-
LIVE
Timcast
1 hour agoTulsi Drops PROOF Obama Ordered COUP Against Trump, Obama FURIOUS
34,124 watching -
UPCOMING
Sean Unpaved
29 minutes agoBrown's QB Battle, Indy's Offense, & RedZone's Hot Sale
-
LIVE
Dr Disrespect
1 hour ago🔴LIVE - DR DISRESPECT - 10 WINS CHALLENGE - BIG ANNOUNCEMENT AT 12PM PT
1,846 watching -
LIVE
Steven Crowder
3 hours ago🔴BREAKING: Tulsi Drops Major Receipts Proving Obama Treason over Trump Russia Hoax
30,423 watching -
LIVE
Nikko Ortiz
1 hour agoLive - Most Painful Clips
231 watching -
LIVE
Barry Cunningham
12 hours agoDON'T MISS TODAY'S WHITE HOUSE PRESS CONFERENCE WITH KAROLINE LEAVITT (AND MORE NEWS)
1,982 watching -
UPCOMING
IrishBreakdown
1 hour agoBig Ten/ACC Going After The SEC - Notre Dame Buy/Sell/Hold
2 -
UPCOMING
Neil McCoy-Ward
52 minutes ago🔥 JUST ANNOUNCED! It's About To Get REAL Between the US & EU! 🇺🇸🇪🇺
38 -
LIVE
The Mel K Show
1 hour agoMORNINGS WITH MEL K - Seditious Conspiracy to Defraud the PEOPLE of the United States of America 7-23-25
1,071 watching -
LIVE
LFA TV
15 hours agoLFA TV ALL DAY STREAM - WEDNESDAY 7/23/25
4,993 watching