public static void QueryFour()
{
using (var dbContext = new AdventureWorks2014Entities())
{
Console.WriteLine("Enter last name to search email addresses: ");
var lastName = "Gonzalez";
var people = dbContext.People
.Where(x => x.LastName == lastName)
.Select(x => x);
foreach (var person in people)
{
foreach (var email in person.EmailAddresses)
{
Console.WriteLine(email.EmailAddress1);
}
}
}
}