Visual Studio Magazine

Selecting Items from a Collection using Another Collection with LINQ Joins

Here's the problem: you have a collection of objects with lots of information in those objects (the "rich" objects). You also have a collection of objects that represent a selection your user made in ...
Visual Studio Magazine

Leverage Joins in Entity Framework To Get Just the Data You Want

Let's say, for example, that you want to retrieve all of the SalesOrderDetails for SalesOrders that have a delivery date in the future. You could write this query to follow the SalesOrderDetail ...