using System;

using System.Linq;

using System.Collections.Generic;

​

public class Program

{

    public static void Main()

    {

        List<Employee> employees = new List<Employee>()

        {

        new Employee()

        {

        FirstName = "John", LastName = "Smith", StateId = 1

        }

​

        , new Employee()

        {

        FirstName = "Jane", LastName = "Doe", StateId = 2

        }

​

        , new Employee()

        {

        FirstName = "Jack", LastName = "Jones", StateId = 1

        }

        , new Employee() 

        {

        FirstName = "Sue", LastName = "Smith", StateId = 3

        }

        };

        List<State> states = new List<State>()

        {

        new State()

        {

        StateId = 1, StateName = "PA"

        }

​

        , new State()

        {

        StateId = 2, StateName = "NJ"

        }

        }

​

        ;

        var empState =

            from emp in employees

            join s in states on emp.StateId equals s.StateId

            select new

            {

            emp.FirstName, s.StateName

            }

​

        ;

        foreach (var e in empState)

        {

            Console.WriteLine("{0} {1}", e.FirstName, e.StateName);

        }

        ;

        Console.WriteLine(Environment.NewLine);

        var outerJoin = from emp in employees

                        join s in states

                        on emp.StateId equals s.StateId

                        into employeeGroup 

            from item in employeeGroup.DefaultIfEmpty(new State{StateId=0,StateName=""})

            select new {emp.LastName,item.StateName};

        foreach (var employee in outerJoin) {

Console.WriteLine(employee.LastName + ", " + employee.StateName); }

    }

}

​

public class Employee

{

    public string FirstName

    {

        get;

        set;

    }

​

    public string LastName

    {

        get;

        set;

    }

​

    public int StateId

    {

        get;

        set;

    }

}

​

public class State

{

    public int StateId

    {

        get;

        set;

    }

​

    public string StateName

    {

        get;

        set;

    }

}

​

​