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