LINQ查询

#region LINQ查询

    public class Student 
    {
        public string id { get; set; }
        public string age { get; set; }
        public string six { get; set; }
        public List<int> Scores { get; set; }
    }

    public void LINQQueryMethodData()
    {
        //  LINQ查询的两种形式:
        int[] nums = {5,6, 1, 2, 3, 4, 5, 6, 7, 8, 9 };
        //  Method Syntax 查询方法方式
        var data = from num in nums where num % 2 != 0 orderby num select num;
        //  Query Syntax  查询语句方式
        var list = nums.Where(item => item % 2 == 0).Select(i => i * i).OrderByDescending(i => i);


        Student student = null;
        List<Student> students = new List<Student>();
        students.Add(student = new Student() { id = "1", age = "18",  six = "女",  Scores = new List<int> { 60, 60, 80 } });
        students.Add(student = new Student() { id = "2", age = "28",  six = "男",  Scores = new List<int> { 54, 60, 80 } });
        students.Add(student = new Student() { id = "3", age = "20",  six = "女",  Scores = new List<int> { 53, 58, 54 } });

        students = (from item in students from score in item.Scores where score >= 60 select item).ToList();
        var studentData = from item in students from score in item.Scores where score >= 60 select item;

        students = studentData.ToList();

        students = students.Where((x, i) => students.FindIndex(z => z.id == x.id) == i).ToList();   //去重

        //  生成类查询
        var num1 = Enumerable.Range(1, 20);
        var num2 = Enumerable.Repeat("LINQ查询", 10);



    }
    #endregion