Home » VB.Net » VB.Net Programs

VB.Net program to select specified fields using Any() LINQ extension method

Here, we are going to learn how to select specified fields using Any() LINQ extension method in VB.Net?
Submitted by Nidhi, on January 26, 2021 [Last updated : March 08, 2023]

VB.Net – Selecting specified fields using Any()

In this program, we will Any() LINQ extension method to check any employee whose age is greater than 22 or not and then print the appropriate message on the console screen.

Program/Source Code:

The source code to select specified fields using Any() LINQ Extension method is given below. The given program is compiled and executed successfully.

VB.Net code to select specified fields using Any() LINQ extension method

'VB.NET program to demonstrate the 
'LINQ Any() extension method.

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
    End Class

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

        Dim result As Boolean = empList.Any(Function(e) e.age > 22)

        If (result = True) Then
            Console.WriteLine("There are few employees whose age is greater than 22")
        Else
            Console.WriteLine("There is no any employee whose age is greater than 22")
        End If
    End Sub
End Module

Output

There are few employees whose age is greater than 22
Press any key to continue . . .

Explanation

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

The Main() function is the entry point for the program. In the Main() function we created the list of employees. Here, we checked the age of all employees, if we found the age of any employee is greater than 22 then Any() method will return true, otherwise, it will return false. After that, we printed the appropriate message on the console screen.

VB.Net LINQ Query Programs »

---