Adventure.Works.LiveDemo.Startup.QueryFive C# (CSharp) Method

        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);
                    }
                }
            }
        }