Join Operator : Join « LINQ « C# / CSharp Tutorial






using System;
using System.Linq;
using System.Collections;
using System.Collections.Generic;


public class Employee {
    public int id;
    public string firstName;
    public string lastName;

    public static ArrayList GetEmployeesArrayList() {
        ArrayList al = new ArrayList();
        al.Add(new Employee { id = 1, firstName = "J", lastName = "R" });
        al.Add(new Employee { id = 2, firstName = "W", lastName = "G" });
        al.Add(new Employee { id = 3, firstName = "A", lastName = "H" });
        al.Add(new Employee { id = 4, firstName = "D", lastName = "L" });
        al.Add(new Employee { id = 101, firstName = "K", lastName = "F" });
        return (al);
    }
    public static Employee[] GetEmployeesArray() {
        return ((Employee[])GetEmployeesArrayList().ToArray());
    }
}
public class EmployeeOptionEntry {
    public int id;
    public long optionsCount;
    public DateTime dateAwarded;

    public static EmployeeOptionEntry[] GetEmployeeOptionEntries() {
        EmployeeOptionEntry[] empOptions = new EmployeeOptionEntry[] {
      new EmployeeOptionEntry {
        id = 1,
        optionsCount = 2,
         dateAwarded = DateTime.Parse("1999/12/31") },
       new EmployeeOptionEntry {
        id = 101,
        optionsCount = 2,
        dateAwarded = DateTime.Parse("1998/12/31") }
    };

        return (empOptions);
    }
}
public class MainClass {
    public static void Main() {
        Employee[] employees = Employee.GetEmployeesArray();
        EmployeeOptionEntry[] empOptions = EmployeeOptionEntry.GetEmployeeOptionEntries();
        var employeeOptions = employees
          .Join(
            empOptions,      
            e => e.id,       
            o => o.id,       
            (e, o) => new    
                      {
                          id = e.id,
                          name = string.Format("{0} {1}", e.firstName, e.lastName),
                          options = o.optionsCount
                      });

        foreach (var item in employeeOptions)
            Console.WriteLine(item);

    }
}








22.8.Join
22.8.1.Join two object lists
22.8.2.Use join key word
22.8.3.Join three object list
22.8.4.Use Join on
22.8.5.Join Operator
22.8.6.Cartesian Join demo
22.8.7.Use == in join
22.8.8.Simple Join
22.8.9.OrderBy joined value
22.8.10.Join on substring