Adventure.Works.LiveDemo.Startup.QueryFour C# (CSharp) Метод

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