Like this: List<Person> pr = db.Persons .Join(db.PersonExceptions, p => p.ID, e => e.PersonID, (p, e) => new { p, e }) .Where(z => z.e.CreatedOn >= fromDate) .OrderByDescending(z => z.e.CreatedOn) .Select(z => z.p) .ToList(); Note how a new anonymous type is introduced to carry both the p and e bits forward. In the specification, query operators … Read more
To answer your question about translation, the query expression will always be translated based on the rules on 7.16 of the C# 4 spec (or the equivalent in the C# 3 spec). In the example where you’re asking the question about the Name property, that’s not a matter of the query expression translation – it’s … Read more
Honestly, sometimes it can be situational once you start using Funcs and Actions. Say you are using these three funcs: Func<DataClasses.User, String> userName = user => user.UserName; Func<DataClasses.User, Boolean> userIDOverTen = user => user.UserID < 10; Func<DataClasses.User, Boolean> userIDUnderTen = user => user.UserID > 10; As you can see the first one replaces the lamdba … Read more
var list = stockItems.Select(item => item.StockID).ToList();