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

        public static void QueryThree()
        {
            using (var dbContext = new AdventureWorks2014Entities())
            {
                Console.WriteLine("Enter last name to search: ");
                var lastName = "Gonzalez";

                var peopleBusinessEntityIDs = dbContext.People
                    .Where(x => x.LastName == lastName)
                    .Select(x => x.BusinessEntityID);

                foreach (var businessEntityID in peopleBusinessEntityIDs)
                {
                    Console.WriteLine(businessEntityID);
                }
            }
        }