Blog

C# program to print the employees whose salary between 6000 and 8000 using LINQ

// Program to print the employees whose salary 
// between 6000 and 8000 using LINQ in C#.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

public class Employee
{
    int     ID      ;
    string  Name    ;
    int     Age     ;
    int     Salary  ;


    public override string ToString()
    {
        return ID + " " + Name+" "+Age+" "+Salary;
    }

    static void Main(string[] args)
    {
        List<Employee> employees = new List<Employee>()
        {
             new Employee {ID=101,   Name="Sumit"    ,Age=23, Salary=4000},
             new Employee {ID=102,   Name="Kiran"    ,Age=24, Salary=6000},
             new Employee {ID=103,   Name="Suman"    ,Age=25, Salary=7000},
             new Employee {ID=104,   Name="Raman"    ,Age=26, Salary=9000},
        };

        IEnumerable<Employee> Query =
            from emp in employees
            where emp.Salary >=6000 && emp.Salary<=8000
            select emp;

        Console.WriteLine("ID  Name  Age Salary");
        Console.WriteLine("=====================");
        foreach (Employee s in Query)
        {
            Console.WriteLine(s.ToString());
        }
        Console.WriteLine("=====================");
    }
}

Output

ID  Name  Age Salary
=====================
102 Kiran 24 6000
103 Suman 25 7000
=====================
Press any key to continue . . .