Question

How to sum all the positive values in a list using LINQ with VB.NET

Answer 1

Imports System
Imports System.Linq
Imports System.Collections.Generic

Module Program
    Sub Main()
        Dim list As New List(Of Integer) From {3, 7, -8, 91, 99, 10, -5, 1, 2}

        Dim result = list.Sum(Function(e) If(e > 0, e, 0))
				
        Console.WriteLine(result)
    End Sub
End Module



' run
'
' 213
'

 

70+ SQL courses for beginners and professionals

Answer 2

Imports System
Imports System.Linq
Imports System.Collections.Generic

Module Program
    Sub Main()
        Dim list As New List(Of Integer) From {3, 7, -8, 91, 99, 10, -5, 1, 2}

        Dim result = (From x In list
                      Where x > 0
                      Select x).Sum()

        Console.WriteLine(result)
    End Sub
End Module




' run
'
' 213
'

 

70+ SQL courses for beginners and professionals