ADVERTISEMENT
ADVERTISEMENT

VB.Net program to demonstrate the LINQ Average() function using LINQ query syntax

Here, we are going to demonstrate the LINQ Average() function using LINQ query syntax in VB.Net.
Submitted by Nidhi, on January 27, 2021

In this program, we will use the Average() function in LINQ query syntax. Here, we will find the average salary of Employees and then print the average on the console screen.

Program/Source Code:

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

'VB.NET program to demonstrate the LINQ Average() 
'function using LINQ query syntax.

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 = 22, .salary = 7500},
            New Employee() With {.id = 105, .name = "Anuj", .age = 23, .salary = 8700}
        }

        Dim avgSalary = Aggregate emp In empList Into Average(emp.salary)

        Console.WriteLine("Average Salary of Employee: {0}", avgSalary)
    End Sub
End Module

Output:

Average Salary of Employee: 6816.66666666667
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 average of employees salary using LINQ query and then print the result on the console screen.

VB.Net LINQ Query Programs »



ADVERTISEMENT



ADVERTISEMENT



Comments and Discussions


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.