C# program to print the employees whose name started with 'S' and Age is greater than 23 using LINQ

c# programming, exam questions, c# programming exam-questions,

All Answers

mahmoud2506

2022-05-12

need an explanation for this answer? contact us directly to get an explanation for this answer

Program:

The source code to print employee details using LINQ in C# is given below. The given program is compiled and executed successfully on Microsoft Visual Studio.

// Program to print the employees whose last character 
// of the name is 'n' 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="Ram"      ,Age=24, Salary=6000},
             new Employee {ID=103,   Name="Sohan"    ,Age=25, Salary=7000},
             new Employee {ID=104,   Name="Raman"    ,Age=26, Salary=9000},
        };

        IEnumerable<Employee> Query =
            from emp in employees
            where emp.Name[0]=='S' && emp.Age>23 
            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
=====================
103 Sohan 25 7000
=====================
Press any key to continue . . .

Explanation:

In the above program, we created an Employee class that contains data members ID, Name, Age, and Salary. Here we override the ToString() method to return Employee information. The Employee class also one more method is known as Main().

List<Employee> employees = new List<Employee>()
{
    new Employee {ID=101,   Name="Sumit"    ,Age=23, Salary=4000},
    new Employee {ID=102,   Name="Ram"      ,Age=24, Salary=6000},
    new Employee {ID=103,   Name="Sohan"    ,Age=25, Salary=7000},
    new Employee {ID=104,   Name="Raman"    ,Age=26, Salary=9000},
};

In the Main() method, we created List collection for Employees, It contains information of 4 employees.

IEnumerable<Employee> Query =
    from emp in employees
    where emp.Name[0]=='S' && emp.Age>23 
    select emp;

In the above code, we created a query to get a list of employees whose name started with 'S' and Age is greater than 23 using LINQ. Then we printed the Employee detail using the "foreach" loop on the console screen.

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

C# program to print the employees whose name started with \'S\' and Age is greater than 23 using LINQ

C# program to print the employees whose name started with 'S' and Age is greater than 23 using LINQ

All Answers

C# LINQ Programs

This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now