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
The Bubba Army
21 hours agoImmigrant Truck Driver.. Who's To Blame?! - Bubba the Love Sponge® Show | 8/20/25
19,062 watching -
32:50
Uncommon Sense In Current Times
16 hours agoIs War Ever Just? Frank Turek Explains Just War Theory & Christian Ethics
5.55K -
25:57
DeVory Darkins
1 day ago $12.57 earnedNewsom suffers HUMILIATING SETBACK after FATAL Accident as Trump leads HISTORIC meeting
30.2K125 -
LIVE
FyrBorne
11 hours ago🔴Warzone M&K Sniping: First Impressions of Black Ops 7 Reveal
288 watching -
8:16
MattMorseTV
16 hours ago $8.42 earnedTrump’s name just got CLEARED.
70.8K72 -
2:01:55
MG Show
20 hours agoPresident Trump Multilateral Meeting with European Leaders; Trump Outlines Putin Zelenskyy Meeting
25K19 -
LIVE
DoldrumDan
2 hours agoCHALLENGE RUNNER BOUT DONE WITH ELDEN RING NIGHTREIGN STORY MODE HUGE GAMING
79 watching -
10:59
itsSeanDaniel
1 day agoEuropean Leaders INSTANTLY REGRET Disrespecting Trump
19.6K16 -
16:43
GritsGG
16 hours agoThey Buffed This AR & It Slaps! Warzone Loadout!
18.1K1 -
2:05:30
Side Scrollers Podcast
20 hours agoEveryone Hates MrBeast + FBI Spends $140k on Pokemon + All Todays News | Side Scrollers Live
114K12