ADVERTISEMENT
ADVERTISEMENT

VB.Net program to demonstrate the Where clause in LINQ query

Here, we are going to demonstrate the Where clause in LINQ query in VB.Net.
Submitted by Nidhi, on January 24, 2021

In this program, we will use Where clause in LINQ query to get the list of employees whose age greater than 23.

Program/Source Code:

The source code to demonstrate the Where clause in the LINQ query is given below. The given program is compiled and executed successfully.

'VB.NET program to demonstrate the Where clause 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
    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 = 24},
        New Employee() With {.id = 105, .name = "Akki", .age = 25}
    }

    Dim Result = From emp In empList
                 Where emp.age > 23
                 Select emp.name

    Console.WriteLine("Employee Names: ")
    For Each na As String In Result
        Console.Write(na & " ")
    Next
    Console.WriteLine()
    End Sub
End Module

Output:

Employee Names:
Amar Akki
Press any key to continue . . .

Explanation:

In the above program, we created a module Module1 that contains a class Employee and the Main() function. The Main() function is the entry point for the program.

The Employee class contains data member "id", "name" and "age". In the Main() function, We create the list of employees. Here, we got the name of the employee whose age is greater than 23 and printed them on the console screen.

VB.Net LINQ Query Programs »



ADVERTISEMENT




ADVERTISEMENT


Comments and Discussions!

ADVERTISEMENT

ADVERTISEMENT

ADVERTISEMENT

ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.