Join Person and Salaries lists to get the max and min salary : Query « LINQ « VB.Net

Home
VB.Net
1.2D
2.Application
3.Class
4.Data Structure
5.Data Types
6.Database ADO.net
7.Date Time
8.Development
9.Event
10.File Directory
11.Generics
12.GUI
13.Internationalization I18N
14.Language Basics
15.LINQ
16.Network Remote
17.Reflection
18.Security
19.Thread
20.Windows Presentation Foundation
21.Windows System
22.XML
23.XML LINQ
VB.Net » LINQ » Query 




Join Person and Salaries lists to get the max and min salary
  

Imports System.Reflection
Imports System


Public Class Role
    Public ID As Integer
    Public RoleDescription As String
End Class

Public Class Person
    Public ID As Integer
    Public IDRole As Integer
    Public LastName As String
    Public FirstName As String
End Class

Public Class Salary
    Public IDPerson As Integer
    Public Year As Integer
    Public SalaryYear As Double
End Class

Module Module1

    Sub Main()
        Dim people As New List(Of Person)(New Person() { _
            New Person With {.ID = 1, .IDRole = 1, .LastName = "A", .FirstName = "Brad"}, _
            New Person With {.ID = 2, .IDRole = 2, .LastName = "G", .FirstName = "Tom"_
        })

        Dim roles As New List(Of Role)(New Role() { _
            New Role With {.ID = 1, .RoleDescription = "Manager"}, _
            New Role With {.ID = 2, .RoleDescription = "Developer"_
        })


        Dim salaries As New List(Of Salary)(New Salary() { _
                New Salary With {.IDPerson = 1, .Year = 2004, .SalaryYear = 10000.0}, _
                New Salary With {.IDPerson = 1, .Year = 2005, .SalaryYear = 15000.0}, _
                New Salary With {.IDPerson = 2, .Year = 2005, .SalaryYear = 15000.0_
        })
        
        Dim query = From p In people, s In salaries _
            Where p.ID = _
            Select s.SalaryYear

        Console.WriteLine("Minimum Salary:")
        Console.WriteLine(query.Min())

        Console.WriteLine("Maximum Salary:")
        Console.WriteLine(query.Max())

    End Sub

End Module

   
    
  














Related examples in the same category
1.Convert Linq result to Array
2.Convert Linq result to List
3.Linq Over Array
4.Linq Over int Array
5.A select statement against object list
6.Filter by name length
7.Find the cars that are going less than 55 mph, and order by descending PetName
8.Create a query expression
9.Convert query to a list of string
10.Get all cars. Similar to Select * in SQL
11.Get differences
12.Get only the pet names
13.Join two object lists together
14.Reflector Linq result
15.Using where clause to check the first name of a Persion
16.Select by a Property
17.Select by object id
18.Query String Array With Operators
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.