Home » VB.Net » VB.Net Programs

VB.Net program to demonstrate the Max() function in LINQ query

Here, we are going to demonstrate the Max() function in LINQ query in VB.Net.
Submitted by Nidhi, on January 27, 2021 [Last updated : March 08, 2023]

VB.Net – Max() Function in LINQ Query

In this program, we will use Max() function in the LINQ query to find out the age of the oldest employee from the employee's list.

Program/Source Code:

The source code to demonstrate the Max() function in the LINQ query is given below. The given program is compiled and executed successfully.

VB.Net code to demonstrate the example of Max() Function in LINQ Query

'VB.NET program to demonstrate the 
'Max() function in LINQ query.

Imports System
Imports System.IO
Imports System.Linq

Module Module1
    Public Class Employee
        Public id As Integer
        Public name As String
        Public age As Integer
        Public salary As Integer
    End Class

    Sub Main()
        Dim empList = New List(Of Employee) From
        {
            New Employee() With {.id = 101, .name = "Amit", .age = 21, .salary = 5000},
            New Employee() With {.id = 102, .name = "Arun", .age = 22, .salary = 7000},
            New Employee() With {.id = 103, .name = "Aman", .age = 23, .salary = 6000},
            New Employee() With {.id = 104, .name = "Amar", .age = 21, .salary = 6700},
            New Employee() With {.id = 105, .name = "Akki", .age = 26, .salary = 7500},
            New Employee() With {.id = 105, .name = "Anuj", .age = 23, .salary = 8700}
        }

        Dim OldAge = Aggregate emp In empList Into Max(emp.age)

        Console.WriteLine("Age of oldest employee is: {0}", OldAge)
    End Sub
End Module

Output

Age of oldest employee is: 26
Press any key to continue . . .

Explanation

In the above program, we created a module Module1 that contains an Employee class and Main() function. The Employee class contains id, name, age, and salary data members.

The Main() function is the entry point for the program. In the Main() function, We created the list of Employees and then find the age of oldest employee from employees list using LINQ query and then print the result on the console screen.

VB.Net LINQ Query Programs »

---