What is a LINQ join example?

Can you explain what a LINQ join is with an example?

Sure! A LINQ join is used to combine two collections based on a common key. For example, if you have a list of students and a list of courses, you can join them on the student ID.

Can you show me a code example of a LINQ join?

Absolutely! Here's a simple example in C#:

var students = new List<Student> {
    new Student { Id = 1, Name = "Alice" },
    new Student { Id = 2, Name = "Bob" }
};

var courses = new List<Course> {
    new Course { StudentId = 1, CourseName = "Math" },
    new Course { StudentId = 2, CourseName = "Science" }
};

var studentCourses = from student in students
                     join course in courses on student.Id equals course.StudentId
                     select new { student.Name, course.CourseName };

What does the result of that join look like?

The result will be a collection of anonymous objects containing the student's name and their corresponding course name. For example:

• Alice, Math
• Bob, Science