Relations(Joins) in LINQ

Following is the sample which shows how can you use relations in the LINQ for query and get the data out of various objects

class Customer
{
    public int CustomerID;
    public string CustomerName;
}



class Order
{
    public int OrderID;
    public int CustomerID;
    public DateTime OrderDate;
}



class CustomerOrders
{
    public IEnumerable GetCustomerOrders()
    {
        Customer[] customers = {
            new Customer{ CustomerID =1, CustomerName = "Pratap Singh"},
            new Customer{ CustomerID =2, CustomerName = "Sikandar"},
            new Customer{ CustomerID =3, CustomerName = "Ram Parsad Patnaik"}
            };

        Order[] orders = {
            new Order{ CustomerID = 1, OrderID = 1 , OrderDate = Convert.ToDateTime("10/Apr/2004")},
            new Order{ CustomerID = 1, OrderID = 2 , OrderDate = Convert.ToDateTime("3/Jan/2005")},
            new Order{ CustomerID = 3, OrderID = 1 , OrderDate = Convert.ToDateTime("23/Mar/2006")},
            new Order{ CustomerID = 2, OrderID = 1 , OrderDate = Convert.ToDateTime("14/Nov/2005")},
            new Order{ CustomerID = 3, OrderID = 2 , OrderDate = Convert.ToDateTime("19/Dec/2008")}
        };

        var Query = from clist in customers
        join oList in orders
        on clist.CustomerID equals oList.CustomerID
        select clist;

        return Query;
    }

}

Here in sample look at the join part of the LINQ join oList in orders on clist.CustomerID equals oList.CustomerID. In smiliar way you can create various joins and create a relational model in LINQ