public static void QuerySix()
{
using (var dbContext = new AdventureWorks2014Entities())
{
Console.WriteLine("Enter last name to search email addresses: ");
var lastName = Console.ReadLine();
//var emails = from person in dbContext.People
// join emailAddress in dbContext.EmailAddresses
// on person.BusinessEntityID equals emailAddress.BusinessEntityID
// where person.LastName == lastName
// select emailAddress.EmailAddress1;
//var emails = dbContext.People
// .Where(x => x.LastName == lastName)
// .SelectMany(x => x.EmailAddresses)
// .Select(x => x.EmailAddress1);
var emails =
dbContext.People
.Where(x => x.LastName == lastName)
.Join(dbContext.EmailAddresses,
l => l.BusinessEntityID,
r => r.BusinessEntityID,
(l, r) => r.EmailAddress1 );
foreach (var email in emails)
{
Console.WriteLine(email);
}
}
}