002 LINQ Environment

          LINQ can be written in all language of Visual Studio .But syntax are different for languages different.LINQ is available from Visual Studio 2010 and (.Net Framework 3.5) and upper version. Now , we will learn how to create a setup LINQ environment. 

           To do this , you have to install Visual Studio first. There are two options, download Visual Studio Express  or purchase license version of Visual Studio for professional uses. In the example we have downloaded Visual Studio 2015 . First  we need to click on setup, the setup will  start. 

Installation has two option "default" or "customs" , you need to choose default options, Visual Studio will proceed, progress bar will show the progress of installation. 

After that you will see a message that  the installation is completed. If you have downloaded Express version, you need to sign up Microsoft to smooth  performance of Visual Studio.


To  create  a console application 

click  1)File   --> New Project 
       2)Choose --> Console Application

you will get this editor. Please keep in mind, LINQ can be used  for desktop application, web application , mobile application also. For the purpose of training we have chosen console application.




Below is the example of LINQ. There are three example. The first example is simple LINQ query  over an array. The second example of utility of IEnumerable interface.  IEnumerableis heart of LINQ queries, you will learn details it in the letter chapter.The third  example is how complex  object is handle by LINQ queries.

Example

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Linq;

using System.Collections;

namespace ConsoleApplication1

{

      class Program

     {

        static void Main(string[] args)

          {

                         string[] country = { "India", "Brazil", "China", "USA", "Pakistan", "South Afrika", "Japan", "Russia", "Poland", "Sweden" };

 

             /* Example 1 (Simple Select Statement) */

                      var AllCountry = from c in country select c;

                     Console.WriteLine("List of Country");

                     Console.WriteLine("----------------");

 
            foreach (var c in AllCountry)

                    {

                              Console.WriteLine(c);

                      }

                       Console.ReadLine();

                      /* Example 1 (All output as reverse list) */

                     var uppercseCountry = country.Reverse().ToArray();

                    Console.WriteLine("Revese List of Country");

                    Console.WriteLine("----------------");

                     foreach (var c in uppercseCountry)

                     {

                               Console.WriteLine(c);

                      }

                     Console.ReadLine();

                     /* Example 3 (LINQ on Array List) */

                      ArrayList myList = new ArrayList();

                     myList.Add(

                     new student

                      {

                          name = "John",

                          roll = 12,

                           age = 9

                         });

                        myList.Add(

                         new student

                       {

                            name = "John1",

                            roll = 14,

                             age = 8

                        });

                        myList.Add(

                        new student

                        {

                          name = "John2",

                          roll = 13,

                          age = 7

                           });

                         myList.Add(

                         new student

                         {

                                name = "John3",

                                roll = 15,

                                 age = 8

                          });

                        var query = from student s in myList

                                          where s.age > 7

                                          select s;

                       Console.WriteLine("List of Student Over 7 Years of Age");

                        Console.WriteLine("--------------------------------------");

                         foreach (student c in query)

                        {

                                      Console.WriteLine("Name : "+c.name);

                                       Console.WriteLine("Roll : " + c.roll);

                                       Console.WriteLine("Age : " + c.age);

                                       Console.WriteLine("\n");
             }

                        Console.ReadLine();

                        }

                   }

}

public class student

{

                 public string name { get; set; }

                 public int roll { get; set; }

                  public int age { get; set; }

}



After you have written the code, press F5  run the code. You will get the output one by one  as you press the key.


Output :
 

List of Country

----------------

India

Brazil

China

USA

Pakistan

South Afrika

Japan

Russia

Poland

Sweden

Revese List of Country

----------------

Sweden

Poland

Russia

Japan

South Afrika

Pakistan

USA

China

Brazil

India

List of Student Over 7 Years of Age

--------------------------------------

Name : John

Roll : 12

Age : 9

Name : John1

Roll : 14

Age : 8

Name : John3

Roll : 15

Age : 8