Join Two Entities in .NET Core Using Lambda and Entity Framework Core
· 11 min read
Entity Framework Core maps each database table to an entity class and gives you a DbContext to query them. Most of the time you read from a single DbSet, but sooner or later you need data that lives across two tables — exactly what a SQL JOIN gives you. In EF Core, the lambda-based Join() method does the same job, and it translates into real SQL that runs on the database server.
Everything below targets .NET 10 and EF Core 10, the current Long Term Support releases.