[C#] LINQ

            string[] words = { "hello", "wonderful", "LINQ", "beautiful", "world" };

            IEnumerable<string> shortWords = 
                from word in words 
                where word.Length <= 5 
                select word;

            foreach(string word in shortWords)
            {
                Console.WriteLine(word);
            }

---

            // 1. Data source
            int[] numbers = { 0, 1, 2, 3, 4, 5, 6 };

            // 2. 쿼리 만들기
            IEnumerable<int> query =
                from num in numbers
                where (num % 2) == 0
                select num;

            // 3. 쿼리 실행
            foreach(int num in query)
            {
                Console.WriteLine(num);
            }

---

            // 1. Data source
            int[] numbers = { 0, 1, 2, 3, 4, 5, 6 };

            // 2. 쿼리 만들기
            IEnumerable<int> query =
                from num in numbers
                where (num % 2) == 0
                select num;

            // 3. 쿼리 실행
            // 새 컬렉션을 얻는다
            List<int> list = query.ToList<int>();
            foreach(int num in list)
            {
                Console.WriteLine(num);
            }

---

        public App()
        {
            List<Student> students = new List<Student>
            {
                new Student { Name = "hong", Score = 88 },
                new Student { Name = "lin", Score = 99 },
                new Student { Name = "jang", Score = 78 },
                new Student { Name = "kim", Score = 100 },
                new Student { Name = "lee", Score = 65 }
            };            

            IEnumerable<string> query =
                from student in students
                where student.Score > 80
                orderby student.Score ascending
                select student.Name;

            foreach (string name in query)
            {
                Console.WriteLine(name);
            }
        }

                orderby student.Score descending

---

            string[] fruits = { "apple", "passionfruit", "banana", "mango", "orange", "blueberry", "grape", "strawberry" };

            // 쿼리식
            IEnumerable<string> query1 =
                from fruit in fruits
                where fruit.Length < 6
                select fruit;

            foreach (string fruit in query1)
            {
                Console.WriteLine(fruit);
            }
            Console.WriteLine();

            // 쿼리 메서드
            IEnumerable<string> query2 = fruits.Where(fruit => fruit.Length < 6);

            foreach (string fruit in query2)
            {
                Console.WriteLine(fruit);
            }

---

        public App()
        {
            string[] fruits = { "apple", "passionfruit", "banana", "mango", "orange", "blueberry", "grape", "strawberry" };

            // 쿼리 메서드
            IEnumerable<string> query1 = fruits.Where(fruit => fruit.Length < 6);

            IEnumerable<string> query2 = query1.Select(x => "delicious " + x);
            foreach (string fruitName in query2)
            {
                Console.WriteLine(fruitName);
            } Console.WriteLine();

            IEnumerable<string> query3 = query1.OrderBy(x => x.Length); // 오름차 순으로 정렬
            foreach (string fruitName in query3)
            {
                Console.WriteLine(fruitName);
            }
        }

---