C#LINQ的join和let语句使用方法

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;


namespace LINQtest
{

    class Program
    {
        public class Student //声明student类
        {
            public int stId; //学生ID
            public string stuName; //学生姓名
        }

        public class Course //声明course类
        {
            public int stId; //学生ID
            public string courseName; //课程名
        }

        static Student[] students = new Student[]
        {
             new Student {stId = 1,stuName = "jack"},
             new Student {stId = 2,stuName = "taylor"},
             new Student {stId = 3,stuName = "fleming"}
        };

        static Course[] courses = new Course[]
        {
             new Course{stId = 1,courseName = "art"},
             new Course{stId = 2, courseName = "art"},
             new Course{stId = 1,courseName = "history"},
             new Course{stId = 3, courseName = "history"},
             new Course{stId = 3,courseName = "physics"},
        };

        static void Main(string[] args)
        {
            //查询所有选修了history课的学生名
            var query = from s in students  //从学生列表中选择符合条件的Student
                        join c in courses on s.stId equals c.stId  //连接到课程列表中满足条件的Course
                        where c.courseName == "history"//连接到课程列表中满足条件的Course
                        select s.stuName;

            foreach (string str in query)
            {
                Console.WriteLine($"{str} "+"选修了历史课");
            }
            Console.ReadKey();
        }
    }


}

let 应用

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;


namespace LINQtest
{

    class Program
    {


        static void Main(string[] args)
        {
          
            int[] groupA = new int[] { 1, 2, 3, 45, 6 };
            int[] groupB = new int[] { 11, 12, 8, 9, 10 };
            var query2 = from a in groupA
                        from b in groupB
                        let sum = a + b
                        where sum < 12
                        select new int[] { a, b, sum };
            foreach (var str in query2)
            {
                foreach (var str2 in str)
                {
                    Console.Write($"{str2}" + "..");
                }
                Console.WriteLine("");
            }

            Console.ReadKey();
        }
    }


}