Home »
VB.Net »
VB.Net Programs
VB.Net program to select specified fields using Any() LINQ extension method
By Nidhi Last Updated : November 16, 2024
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 »