using System;

using System.Linq;  

using System.Collections.Generic;

public class Program

{

    public static void Main()

    {

        //Console.WriteLine("Hello World");

        Program.ApplyLinqToDotNetCollections();

        Console.WriteLine();

        Program.CollectionLambda();

    }

     static void ApplyLinqToDotNetCollections()

        {

            // Make a List<> of Car objects.

            List<Car> myCars = new List<Car>() {

            new Car{ PetName = "Henry", Color = "Silver", Speed = 100, Make = "BMW"},

            new Car{ PetName = "Daisy", Color = "Tan", Speed = 90, Make = "BMW"},

            new Car{ PetName = "Mary", Color = "Black", Speed = 55, Make = "VW"},

            new Car{ PetName = "Clunker", Color = "Rust", Speed = 5, Make = "Yugo"},

            new Car{ PetName = "Melvin", Color = "White", Speed = 43, Make = "Ford"}

            };

        // var query=from c in myCars where c.Make=="BMW" select c; select c only gives type of object example:car not actual data

         var query=from c in myCars where c.Make=="BMW" orderby c.PetName select c;

         foreach(var q in query)

             Console.WriteLine("Name:{0} Color:{1}",q.PetName,q.Color);

        }

    static void CollectionLambda()

        {

            // Make a List<> of Car objects.

            List<Car> myCars = new List<Car>() {

            new Car{ PetName = "Henry", Color = "Silver", Speed = 100, Make = "BMW"},

            new Car{ PetName = "Daisy", Color = "Tan", Speed = 90, Make = "BMW"},

            new Car{ PetName = "Mary", Color = "Black", Speed = 55, Make = "VW"},

            new Car{ PetName = "Clunker", Color = "Rust", Speed = 5, Make = "Yugo"},

            new Car{ PetName = "Melvin", Color = "White", Speed = 43, Make = "Ford"}

            };

        // var query=from c in myCars where c.Make=="BMW" select c; select c only gives type of object example:car not actual data

         //var query=from c in myCars where c.Make=="BMW" orderby c.PetName select c;

        var query=myCars.Where(c=>c.Make=="BMW").OrderBy(c=>c.PetName).Select(c=>c);//As Collections contains different types of data must specify in orderby a specific column

         foreach(var q in query)

             Console.WriteLine("Name:{0} Color:{1}",q.PetName,q.Color);

        }

}

class Car{

    public String PetName{get; set;}

    public String Color{get; set;}

    public int Speed{get;set;}

    public String Make{get;set;}

};