Get the count of all employees hired this year. : Count « LINQ « VB.Net

Home
VB.Net
1.2D
2.Application
3.Class
4.Data Structure
5.Data Types
6.Database ADO.net
7.Development
8.Event
9.File Directory
10.Generics
11.GUI
12.Language Basics
13.LINQ
14.Network Remote
15.Security
16.Thread
17.Windows Presentation Foundation
18.Windows System
19.XML
20.XML LINQ
VB.Net Tutorial
VB.Net by API
VB.Net » LINQ » CountScreenshots 
Get the count of all employees hired this year.
    

Imports System
Imports System.Xml.Linq

    Public Class MainClass
        Public Shared Sub Main()
            Dim employees As XElement = XElement.Load("Employees.xml")
            Dim cnt = Aggregate ele In employees.<Employee> _
                      Where CDate(ele.<HireDate>.Value).Year = Now.Year _
                      Into Count()

            Console.WriteLine("{0} employees were hired this year.", cnt)
            

        End Sub

    End Class

   
    
    
    
  
Related examples in the same category
1.Get count from the query
2.Using Count to return a list of employeeList and how many orders each has
3.Using Count to return a list of categories and how many projectList each has
4.Aggregating Count with Conditional
5.Using Aggregating Count to get the number of unique factors of 300
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.